Tame Those Strings - Using SUBSTRING
In this article by Steve Jones, he shows you how to manipulate strings.
2004-04-05
17,621 reads
SQLYSE with Pankaj Manek
Related content
Tame Those Strings! Part 2 - Using CHARINDEX
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
2002-05-31
15,589 reads
Undocumented T-SQL Tricks With Logs
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
2001-06-27
14,788 reads
Tame Those Strings! Part 5 - Using STUFF
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2001-06-21
10,855 reads
SP_MSForeachtable - Life Without Cursors.
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,187 reads