I'm not a fan of the BETWEEN operator. While the syntax is very easy to understand and requires less typing than my favorite alternative, it can lead to situations where unwanted results are returned. Because of this I've gotten into the habit of avoiding it all together. If you'd like a refresher on BETWEEN, its …

Read More

Most T-SQL guides and tutorials I've seen concentrate on the following transaction commands: BEGIN, COMMIT, and ROLLBACK, which I'll henceforth refer to as the "big three". While they're certainly very important, there's also a fourth command, SAVE, which is typically treated like a distant cousin who's only …

Read More

No more than an output to me, but it sure was to SQL Server! This issue kept me busy over the weekend, and most definitely gave me a case of Saturday Night SQL Fever (as opposed to "SQL Saturday Night Fever", for which the only cure is more karaoke). When executing a stored procedure with an OUTPUT parameter, …

Read More