Tame Those Strings - Part 9
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2002-04-04
7,642 reads
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2002-04-04
7,642 reads
2002-04-03
2,234 reads
As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that deal with the licensing aspects of using SQL Server.
2002-03-21
5,058 reads
This article looks at the T-SQL CAST function and how it is used and preferred to CONVERT().
2002-03-18
16,787 reads
Steve Jones completed an online eLearning course with IMG University that provided an introduction to the OLAP / Analysis services available with SQL Server 2000. This article examines some of his impressions from this vendor.
2002-03-12
3,034 reads
I found this on the Internet, but I think it's really my own personal list.
2002-03-08
2,626 reads
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
2002-03-04
11,036 reads
2002-03-01
2,215 reads
Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.
2002-02-25
5,976 reads
2002-02-15
3,562 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