This Function is a small script to retrieve the age of person based on date of birth to a particular date.Eg.select dbo.GetDateofbirth ('01/01/1975',GETDATE())RETURNS29Years 2Months 24Days that is the age.TESTED only on SQLSERVER 2000
2004-03-25
400 reads
This Function Enables the user to retrieve the Last Index of the character/string in a predetermined string.Eg If you want search for the Last Occurance of 'SQL' in 'SQL SERVER2000 USES ANSI SQL' thenSELECT dbo.LastIndexOf('SQL SERVER2000 USES ANSI SQL','SQL')will return 26.Tested Only in SQL SERVER2000
2004-03-25
2,810 reads
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
2026-02-05 (first published: 2004-03-25)
9,085 reads
Function RJZeroN is used for formatting integer numbers as right-justified strings with leading zeroes according to a specified size (max 20 characters which will hold the largest BIGINT value). A NULL value is returned if the formatting cannot be done according to the values specified.Example: Format a 3-digit number as a 7-character numberstring with leading […]
2004-03-24
962 reads
Found a version of this on the net. removed the loop and if/thens and made it a case statement 2004-03-11: Changed '@%@' to '%@%@%'
2004-03-08
425 reads
This script uses the extended stored procedure xp_instance_regread to read a value from the registry
2004-02-20
1,486 reads
This script uses an old mathematical way of doing hierarchical queries. The most common way of showing hierarchical data in SQL Server is by creating a stored procedure that calls itself. This is not a recent problem, in fact this programming technique has been around since the first programming languages. By using stacks, you can […]
2007-05-02 (first published: 2004-02-17)
587 reads
2004-09-30 (first published: 2004-02-16)
97 reads
2004-10-01 (first published: 2004-02-16)
138 reads
This stored procedure is created from the need to copy rows from a table with new value. The script itself will create stored procedure proc_copyrows.The parameters are@TableName: the table name@FilterField: filter field, default is null, means no filter@SourceValue: the value of filter field from source data to be copied@DestinationValue: the new value of filter field@SourceDB: […]
2004-02-13
266 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers