There are many occasions in programs where you need to manipulate strings of characters that are delimited by a particular character, such as a comma, or a space. This function enables you to extract a substring from the string at a specified occurence of the delimter. declare @Data varchar(255) set @Data = 'A,B,C,D,E' print dbo.field(@data,',',2,2) […]
2011-11-07 (first published: 2007-08-03)
2,639 reads
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,542 reads
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,331 reads
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-03 (first published: 2011-10-12)
7,901 reads
2011-11-02 (first published: 2011-10-21)
1,783 reads
2011-11-01 (first published: 2011-10-18)
2,572 reads
2011-10-31 (first published: 2011-10-19)
2,282 reads
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
2011-10-28 (first published: 2008-05-13)
3,019 reads
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.
2011-10-27 (first published: 2008-02-08)
3,467 reads
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
3,518 reads
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I