I run EXEC sp_who2 78 and I get the following results: How can I find why its status is suspended? This process is a heavy INSERT based on an expensive query. A big SELECT that gets data from …
How to debug a T-SQL trigger?
I have a table t, which has an “after insert” trigger called trgInsAfter. Exactly how do i debug it? i’m no expert on this, so the question and steps performed might look silly. The steps i performed so far are: 1. connect to the server instance via SSMS (using a Windows Admin account) right…
Cannot write property IsFileStream
Everytime I try to create a new Database in SQL—haven’t accomplished to create any, so far. Please, help me with a detailed solution for this. TITLE: Microsoft SQL Server Management Studio Cannot …
How to delete a stored procedure?
Using this we can create procedure then how to delete,alter…etc,Can any one help me how to delete procedure. Answer Try this USE [PSI Data] DROP PROCEDURE [dbo].[savepsi]; GO
What is this operator in MySQL?
I’m working on code written by a previous developer and in a query it says, What does <=> mean in this query? Is it something equal to =? Or is it a syntax error? But it is not showing any errors or exceptions. I already know that <> = != in MySQL. Answer TL;DR It’s the NULL safe equal…
Two entities with possibly different keys are mapped to the same row
I have Table Field1 PK int not null Field2 PK int not null like this when i want to map this table I get this error Error 3 Error 3034: Problem in mapping fragments starting at lines 2212, …
Oracle Regular Expression (REGEXP_LIKE) Too Long Error – ORA-12733
I have to validate an IPv6 address in PL/SQL. I came up with the regular expression from here: Regular Expression (RegEx) for IPv6 Separate from IPv4 I am getting an ORA-12733: regular expression too long error. Is there any way around this? The limit is 512 (https://stackoverflow.com/a/2694119/3112803), I…
Does Liquibase support dry run?
We have couple of data schemas and we investigate the migration to Liquibase. (One of data schemas is already migrated to Liquibase). Important question for us is if Liquibase supports dry run: We …
sql: scan row(s) with unknown number of columns (select * from …)
I have a table t containing a lot of columns, and my sql is like this: select * from t. Now I only want to scan one column or two from the wide returned row set. However, the sql.Scan accepts dest ……
SQL Server : round and add percent sign
I have the following SQL query that is returning a result of 92.967013425802 and I need it to be formatted like 93% and add the percent sign. I have tried changing the sum to round but I received an …