Recommended books for transact sql programming in a Sql Server 2005 environment

• mgodinez

  SSC Enthusiast

  Points: 124

  More actions

  October 15, 2009 at 11:39 am

  #210969

  Hello,

  I really had my heart set on buying Ken Henderson's, The Guru's Guide to Transact-SQL. But from the current reviews I'm seeing, DBAs and programmers in the field seem to think that this book is dated.

  Can anyone recommend a good book to transact SQL programming in a Sql Server 2005 environment? I'm hoping to find a book w/ copious basic transact sql programming examples (i.e. pivot function, basic queries/subqueries, delegating user permissions for a schema, etc.).

  Thanks.

  Regards,

  Mike G.

  Seattle, WA

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  October 16, 2009 at 6:19 am

  #1066825

  The best straight T-SQL book out there, in my opinion, is Itzik Ben-Gan's Inside T-SQL Querying. Fantastic. It should do most of what you need.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning