SQL Server – Various methods to generate unique number sequence
Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number...
2015-09-28
646 reads
Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number...
2015-09-28
646 reads
HI friends, in some working scenario or during interviews we got the task to find the running totals of a...
2015-09-14
598 reads
Hi friends, I was working on a scenario in which I need to assign a unique values to a column....
2015-09-08
613 reads
Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different...
2015-08-03
655 reads
Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of...
2015-07-26
667 reads
Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query...
2015-07-25
642 reads
In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced...
2015-07-23
730 reads
Hi friends, today I will get you introduced with another new feature of SQL Server 2016 i.e. Temporal Tables. SQL...
2015-07-23 (first published: 2015-07-20)
3,089 reads
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,099 reads
Hi friends, in next few blogs we will explore another new feature named Query Store which gets introduced in SQL...
2015-07-16
701 reads
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