Home Forums SQL Server 2008 SQL Server Newbies good book or webite to learn the basic on TSQL and/or SQL server RE: good book or webite to learn the basic on TSQL and/or SQL server

  • August 7, 2013 at 11:21 pm

    #1639614

    Sean Lange (8/7/2013)

    You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced as they go.

    Also, make sure you check out the question of the day (QotD) on the left side. It is a great learning tool about a variety of topics. Make sure you follow the discussions. Often times the discussion is more informative than the question itself.

    Be advised that at least one author over on the "stairway" has an extremely annular fixation on the use of ANSI-only code. Of course, that's great for the basics but it won't cover things like how to use the proprietary UPDATE of SQL Server, which can be a whole lot faster than an ANSI standard update when trying to update many columns. The UPDATE statement in SQL Server doesn't actually meet ANSI standards since you can't list multiple columns around a single "=".

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)