|
|
-
Pothiraj Posted 4 Months ago through Ask
Hi All,
Is there any way to drop a constraint without disabling CDC.
We need to drop and recreate a constraint in our CDC enabled database. We got the error while executing the drop constraint statement. It is working fine, if we disable the CDC. But w...
|
-
Pothiraj Commented 7 Months ago through Just Learned
It will copy the Identity property to the new table....
|
-
Pothiraj Commented 7 Months ago through Ask
I think, below code will help you. In sLog table, I have used ErrorID as a Identity column.
INSERT INTO sDetail
SELECT BatchID,
(SELECT COUNT(I1.ID)
FROM sMaster I1
WHERE I1.BatchID = o.BatchID AND (I1.Sid <> '' A...
|
-
Pothiraj Commented 7 Months ago through Ask
Please try this one:
; WITH CTE AS
(
SELECT I.UID, I.Date, I.Description, I.CategoryId, I.Amount AS IAmount, 0 AS EAmount
FROM TblIncome I
UNION
SELECT E.UID, E.Date, E.Description, E.CategoryId, 0 AS EAmount, E.Amount ...
|
-
Pothiraj Posted 7 Months ago through Ask
We need a SQL query to retrieve table name, column name and type used in a Stored procedure.
If a table/column used in more than one time, it will display all the records instead of distinct records.
I have tried using sys.dm_sql_referenced_entities, ...
|
|
|
-
Pothiraj Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Pothiraj knew 1 Years ago through Just Learned
I have worked with SQL Server bit columns for years, yet even so, to my surprise I just learned that you can not only use 1 and 0, you can also use the literals 'true' and 'false'. Note that they are not explicitly bit data types already, but like 1 and...
|
-
Pothiraj Liked 1 Years ago through Just Learned
I have worked with SQL Server bit columns for years, yet even so, to my surprise I just learned that you can not only use 1 and 0, you can also use the literals 'true' and 'false'. Note that they are not explicitly bit data types already, but like 1 and...
|
-
Pothiraj knew 1 Years ago through Just Learned
I have worked with SQL Server bit columns for years, yet even so, to my surprise I just learned that you can not only use 1 and 0, you can also use the literals 'true' and 'false'. Note that they are not explicitly bit data types already, but like 1 and...
|