New in 2012, they added OFFSET and FETCH.  This is fantastic for paging!  If you’ve ever used MySQL and wished for this in SQL Server, here you go.  Windows Azure SQL DB (SQL Azure) is 2012, by the way.

I don’t know how long this has been around, but I recently needed to generate an MD5 Hash.  The platform I was using didn’t have a function, so I just let SQL Server do the work.

SELECT CONVERT(VARCHAR(MAX), HASHBYTES( ‘MD5′,  ‘Hash Me’), 2)

One Response to “Transact SQL Gems”

1. Jodee Huffines says:

   October 13, 2012 at 2:58 pm

   Hey there this is a terrific blog I just can’t wait to return and read much more.

   Reply

Leave a Reply

Cancel

Name, (required)

Mail (will not be published), (required)

Website

Notify me of followup comments via e-mail

Tweet This