Takes a simple string of delimited values, and returns a table type of the values stripped out. This can be easily incorporated in existing SQL statements utilising standard joins. Classic example of a UDF returning the TABLE data type.
2003-08-10
422 reads
Purpose: To create a User Defined SQL Function that can convert a string into a Proper Case string.Installation: Run the Create Function First then run the Alter Function Statement directly after.
2003-08-07
190 reads
It is sometimes necessary to have information regarding the database objects like stored procedures and triggers for e.g. we need to get information about a stored procedure like what paramters it has and so on.The sp_help system stored procedure comes in handy.What this store procedure does is that it returns result set. The result will […]
2003-08-07
176 reads
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
2003-07-22
19,571 reads
An easy way to organize the data by groups of sequential numbers. This is very helpful for splitting up a large file into numerous smaller files. You can then create the smaller files by filtering for the row number per file.
2003-07-09
214 reads
This script loads from a formatted text file (E.g. tab delimited) with variable number of columns using BULK INSERT. For instance, the file may have any number of columns and next load (seconds later) the same file may have a different number of columns. This script reads the first line (column names) extracting the names […]
2005-03-01 (first published: 2003-06-30)
971 reads
This article by James Travis details the differences between IS NULL and = NULL. He also discusses the ANSI_NULLS setting.
2017-08-18 (first published: 2003-06-17)
142,432 reads
This procedure displays all user-defined datatypes in all databases on a server. Another example of the power of dynamic T-SQL, this procedure dynamically generates SELECT statements for the systypes tables in each database and UNIONs them together so that they display in one recordset.
2003-05-30
151 reads
A lot of table pivoting scripts use cursors to reach the desired results, but SQL scripting was developed to be utilized in a data set environment rather than sequential step-thru scripting.Normally, there are 3 types of Table Pivoting - 1) column explicit 2) column implicit and 3)single column. COLUMN EXPLICIT will place the row value […]
2003-05-29
412 reads
Use SQL's own method to get the current DBName, no function needed.
2003-05-27
1,075 reads
A couple of days ago I was doing some cleaning on some Azure SQL...
Have you ever wanted to filter a visual by selecting a range of values...
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
Not sure if this is the place to ask, but will give it a...
Is there a specific platform or website where I can verify the compatibility between...
Comments posted to this topic are about the item Truncate tables where Referential Integrity...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers