Initcap Function
INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.
2006-05-29 (first published: 2003-07-02)
661 reads
Scripts
Pivot Table Recordset for SQL 2000
This is the basic structure of how to dynamically create a pivot table recordset for SQL 2000. In this example, I am using SUM, but it could just as easy be COUNT or any other aggregate function.
2006-05-26 (first published: 2006-05-08)
1,880 reads
Backup Verification
The following script runs against the current server and retrieves number of days since last full or differential and the number of days between them. it also retrieves the number of hours since the last transaction log backup.It currently returns a grid output.currently the script is under going changes to send XML back to an […]
2006-05-22 (first published: 2006-04-13)
1,247 reads
To move all the table data from database to xls or
To move all the table data from database to xls or doc or txt files tableMany times we come accross to move data from database to external files such as word,xls or data files. Here is the script that move all tables data to specified files. Target file names are the table names. specify the […]
2006-05-20 (first published: 2006-04-05)
1,694 reads
HTML Email Using SQL
This would help you to send HTML email using T-SQL script, you just need to provide necessary parameters and you would have HTML email.
2006-05-19 (first published: 2006-04-19)
1,474 reads
Calculate distance between two points
The calculation of distance between two points using standard spherical geometry can be inaccurate for short distances (ten miles or less) because the sine function of very small angles approaches zero. The haversine approach (http://en.wikipedia.org/wiki/Haversine_formula) turns this around, so it is very accurate at small distances but has larger errors (about ten miles) for points […]
2006-05-18 (first published: 2006-04-25)
701 reads
2006-05-17 (first published: 2006-04-25)
273 reads
2006-05-16 (first published: 2006-04-26)
281 reads
Display Person Initials
Display a person's initials regardless if they have a middle name or not.Just pass in the persons name
2006-05-15 (first published: 2006-04-27)
588 reads
BCP OUT all table data in your Database
Data Recovery is vital. This script will cursor through your database and BCP OUT the table data to a directory specifically for each day of the week (in numbers - where 1 = Sunday and 7 = Saturday) in order to have table recoverability up to 7 days. The first step is to create the […]
2006-05-11 (first published: 2006-05-02)
703 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers