What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their...
2014-10-22
38 reads
I was asked an interesting question about collations in sql server recently about where variables in a script got their...
2014-10-22
38 reads
I was asked an interesting question about collations in sql server recently about where variables in a script got their...
2014-10-22
43 reads
I was asked an interesting question about collations in sql server recently about where variables in a script got their collation's from. I really wasn't too sure of the...
2014-10-22
3 reads
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
35 reads
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
38 reads
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
12 reads
I have worked as a DBA and also as a Sql Server developer and in many roles had full access to production, it is OK though I know what...
2014-10-21
1 reads
I have moved my blog over to here, expect exciting posts about the things that interest me my previous blog...
2014-10-20
52 reads
I have moved my blog over to here, expect exciting posts about the things that interest me my previous blog...
2014-10-20
36 reads
I have moved my blog over to here, expect exciting posts about the things that interest me my previous blog was at: http://sqlserverfunctions.wordpress.com.
I hope you find something you enjoy...
2014-10-20
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers