Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 149, comments - 1924, trackbacks - 64

My Links

SQLTeam.com Links

News

Welcome to my weblog. My name is Jeff Smith, and I am a software developer in Boston, MA. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe





Archives

Post Categories

Programming

Sports

SQL

July 2008 Entries

How To Calculate the Number of Week Days Between two Dates

posted @ Thursday, July 31, 2008 12:39 PM | Feedback (2)

Convert input explicitly at your client; don't rely on the database to "figure it out"

A common mistake beginners make when working with SQL is trying to format things at the database layer. I've covered that quite a bit in various blog posts, but I've only touched upon another similar issue which I feel is equally as important and also very often mishandled. read more...

posted @ Thursday, July 24, 2008 9:12 AM | Feedback (10)

The MailBag --- Super-Sized Edition! String Parsing, Crosstabs, SQL Injection, and more.

posted @ Wednesday, July 16, 2008 4:32 PM | Feedback (0)

Powered by: