Need to proper case names? Want a quick way to reformat a series of words? This article examines a SQL approach to quickly proper casing all words in a field.
2026-02-03 (first published: 2001-10-24)
12,658 reads
Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.
2001-09-19
3,739 reads
This article presents a method of outputting the results of a query as a tab delimited text file using COM.
2001-07-20
6,584 reads
Ever had to calculate the number of business days between two dates? This article presents a way to solve this problem in T-SQL.
2001-07-18
13,009 reads
Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.
2007-10-02 (first published: 2001-07-16)
23,965 reads
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2026-02-03 (first published: 2001-06-21)
10,929 reads
2001-06-15
7,461 reads
One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
2001-06-04
10,715 reads
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
2001-05-31
13,791 reads
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,250 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers