It’s been 3 years since I asked and answered the question. Since then a few things have changed. Here’s the new solution based on ES6, mssql 4 and Express 4 that I would suggest today. Two key elements are at play here. Modules are cached after the first time they are loaded. This means that … Read more
EXEC sp_MSforeachtable @command1=”ALTER TABLE ? NOCHECK CONSTRAINT ALL” GO You may also want to do this: EXEC sp_MSforeachtable @command1=”ALTER TABLE ? DISABLE TRIGGER ALL” GO To enable them afterwards EXEC sp_MSforeachtable @command1=”ALTER TABLE ? ENABLE TRIGGER ALL” GO — SQL enable all constraints – enable all constraints sql server — sp_MSforeachtable is an undocumented system … Read more
To answer the question “is there any preference/difference”: Yes, there are as many preferences as there are opinions, but be careful whose preferences you adopt. As a best practice, it is advisable to write portable SQL if it doesn’t require any extra effort. For your specific sample, it is just as easy to write a … Read more
the am giving you is the code for trigger for INSERT, UPDATE and DELETE this works fine on Microsoft SQL SERVER 2008 and onwards database i am using is Northwind /* comment section first create a table to keep track of Insert, Delete, Update create table Emp_Audit( EmpID int, Activity varchar(20), DoneBy varchar(50), Date_Time datetime … Read more
This is just about the most bizarre query I’ve ever written, but I’m pretty sure it gets the “last 5” rows from a table without ordering: select * from issues where issueid not in ( select top ( (select count(*) from issues) – 5 ) issueid from issues ) Note that this makes use of … Read more
Best method in SQL Server 2016 Example: SELECT FORMAT(GETDATE(), ‘yyyy/MM/dd-HH:mm:ss’, ‘fa’) Answer: 1398/10/08-05:37:59
If you expect infrequent collisions, Optimistic Concurrency is probably your best bet. Scott Mitchell wrote a comprehensive tutorial on implementing that pattern: Implementing Optimistic Concurrency
Sounds to me like you plan to use the varchar(MAX) data type for its intended purpose. When data in a MAX data type exceeds 8 KB, an over-flow page is used. SQL Server 2005 automatically assigns an over-flow indicator to the page and knows how to manipulate data rows the same way it manipulates other … Read more
I finally got it. It turns out there is an issue with the validation, but not only SSIS elements go through that validation, as stated in the fourth failed solution of the question. The CONNECTIONS also get validated and have their own Delay Validation property, which needs to be set to true. After that the … Read more
If it’s always going to be the same length, then binary(length) would be suitable. If it’s going to vary in length, use varbinary(maxlength). binary and varbinary. And, as @p.s.w.g says, you pass it from code by placing it into a suitable parameter.