Browse by Tags

• datetime
• sql server
• T-SQL Tuesday 001

• [T-SQL Tuesday] Some code is born crap, some code achieves crapness and some code has crapness thrust upon it!

  I recently returned to a client at which I last worked back in 2006 and, as you might imagine, that gives me ample material for a blog post dedicated to Crap Code; conveniently the subject of the latest T-SQL Tuesday . I first worked for this client back Read More... Posted Wednesday, August 10, 2011 5:04 PM by jamiet | 0 Comments Filed under: sql server, t-sql, T-SQL Tuesday

• Unambiguous date formats : T-SQL Tuesday #001

  One of the most commonly used data types in SQL Server is [datetime] which unfortunately has some vagaries around how values get casted. A typical method for defining a [datetime] literal is to write it as a character string and then cast it appropriately. Read More... Posted Tuesday, December 08, 2009 9:23 PM by jamiet | 9 Comments Filed under: datetime, sql server, t-sql, T-SQL Tuesday, T-SQL Tuesday 001