Suggestion of book for starters?

  • Can someone suggest me a good book for TSQL for starting users. I am good with Oracle SQL but still need more practice in TSQL. I sql couple of reviews for "TSQL for guru" but it seems like for advanced users.

    Thanks.

    Forgot to mention. We are using SQL server 7.0. Might go to 2000 in future.

    Edited by - hirenk on 10/03/2002 08:21:42 AM

  • Two books spring to mind. Code-Centric: T-SQL Programming with Stored Procedures and Triggers by Garth Wells (Apress). A good basic and not so basic book, nice keyweord reference and a good summary of the system supplied sp's. Also will show you how neanderthal T-SQL's error handling is compared to ORACLE.

    The second is Ken Henderson's The Guru's guide to Transact-SQL (ISBN 0-201-61576-2). THE guide to wrinkles, gotcha's and some nifty coding tricks

    I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961


    I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961

  • Ken's guide is great. I also used "Programming T-SQL" by Kline.

    Here are some reviews on this site:http://www.sqlservercentral.com/articles/articleList.asp?categoryid=75

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • Also in SQL Books Online there are several or so comparisons with SQL to ORACLE code for help. Anything specific you may need to ask. But I liked the WROX Press SQL Developement study guides for the exams, they are layed out well and simple to follow).

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply