This function splits a delimited string (up to 4000 characters long) into a single column table. The delimiter can be specified at the time of execution. If not specified, the delimiter defaults to a comma. The default length of each value is 100, but that can easily be changed.An example for usage:DECLARE @string NVARCHAR(4000)DECLARE @instruments […]
2007-05-25 (first published: 2007-04-10)
5,763 reads
I wrote this code to make it easier to compare record counts between a live database and a restored copy to test my backups, I thought people might find it useful. You need to run it against your live side when you do the backup that you're going to restore and compare against.Copy the output […]
2007-05-24 (first published: 2007-05-07)
2,771 reads
It has always bothered that there is not a NameValuePair function in SQL.
2007-05-23 (first published: 2007-05-16)
202 reads
DESCRIPTION:This procedure produces a SELECT statement which explicitly lists all fields for 'tablename' with fieldname and alias as the column name. The SELECT it produces is ready to run or if you need to join several tables just copy the column names off the SELECT it generates. I use this a lot when I create […]
2007-05-22 (first published: 2007-05-19)
220 reads
DESCRIPTION:This procedure will allow you to display results vertically (down) instead of across the screen. It's great when you are dealing with a query that has 50 columns and just a couple of records. LIMITATIONS: * It will be very slow if you are trying to return a lot of records. Works best for queries […]
2007-05-21 (first published: 2007-05-19)
3,231 reads
This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.
2007-05-18 (first published: 2007-05-07)
449 reads
A simple script to find the database recovery model. Cut & paste into Query Analyser
2007-05-17 (first published: 2007-05-08)
3,004 reads
This code provides a way of monitoring the growth of all your databases within a single instance. The first part is the creation of a monitoring table with the initial load of current databases and sizes. The second part is the SQL that can be put in a scheduled job to automate the growth monitoring.It […]
2007-05-16 (first published: 2007-05-08)
24,370 reads
This is a generalised Function that will return a String in Proper Case [Camel Case]. Means Afetr every space, first later will be in UPPER Case.Example:Input String: 'microSoft sql server'Output String: 'Microsoft Sql Server'
2007-05-09 (first published: 2007-04-19)
22,443 reads
This function will return you the month-end date. Input parameter may be any date of that month for which you want to calculate month-end.Example:Input: '2-20-2004' Output: '2-29-2004'Input: '2-15-2004' Output: '2-29-2004'Input: '3-20-2004' Output: '3-31-2004'Input: '3-30-2004' Output: '3-31-2004'
2007-05-08 (first published: 2007-04-19)
1,356 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Comments posted to this topic are about the item Training the next generation
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers