Category: sql server

Invitation to T-SQL Tuesday #014

Post author By Jen McCown
Post date January 3, 2011
Categories In News-ish, sql server, sqlserverpedia-syndication, SSC
83 Comments on Invitation to T-SQL Tuesday #014

Hello and welcome to the first T-SQL Tuesday of 2011! 2010 was a great year for T-SQL Tuesdays, dreamed up and instigated by Adam Machanic (blog, Twitter) in December of 09 (see his recent blog T-SQL Tuesday Meta Roundup). So tell us, Adam…what is a T-SQL Tuesday? Each month a blog will host the party, […]

T-SQL: CASE Statement

Post author By Jen McCown
Post date December 28, 2010
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on T-SQL: CASE Statement

This is a companion piece to the MidnightDBA video T-SQL: CASE Statement. In short, a CASE statement is a simplified set of IF statements. Instead of using several IF statements, you can have a single statement that evaluates several criteria against a piece of data. Simple CASE Let’s take a simple example. We want to […]

RTFM365, Week 3

Post author By Jen McCown
Post date December 28, 2010
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, TSQL
3 Comments on RTFM365, Week 3

Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my BOL readings, and according to numbers I’ve just made up. I’m sure it’s accurate. The thing that has me preoccupied this week is how much I’m looking up and reading (what one might consider) basics. I […]