One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!
2002-10-11
11,882 reads
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,126 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 Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
By Gethyn Ellis
To be honest you probably think that migrating to the cloud sounds great, and...
Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...
Anyone have any insights on how this licensing works and what the "Use Rights"...
I am working in SSIS (Sql server version 2012) , I have a requirement...
Ask SSC