This SQL2000 function accepts a delimited list of values as a string and the character you want to use as a delimiter.The function then splits these out and returns them as a table.The function assumes that the input string will contain unique integer values.Useage: - SELECT Id FROM fnSplit('1,2,3,4' , ',')
2002-06-27
571 reads
I sometimes have to loop through records in a database and perform a specific action on the value that is returned. For example, In the script below I loop through the user tables in sysobjects and simply print them out. This technique is useful when dropping all indices/triggers on a particular table, or adding WITH […]
2001-11-25
9,125 reads
2001-09-04
3,033 reads
What skills do you need to be a DBA? Lots of different ones, but people often forget there are non-technical skills that matter. This article by David Poole examines some of the softer skills
that can help your career.
2001-08-28
7,917 reads
By Kamil
Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of...
Back with a new focus First let me say wow can’t believe that it...
By Steve Jones
I’m traveling back from Australia today. A few weeks ago I lost a day...
Comments posted to this topic are about the item Statistics Profile Results
I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...
Comments posted to this topic are about the item Temporary data and Differential Backup...
Ask SSC