SQL Query writing

Posted on 2011-04-26
Last Modified: 2012-08-13
hi all

can anyone recommend me a good sql 2005 query writing book?
im probably at intermediate level (i can write reports, triggers and basic sp's)- i can usually get the job done but maybe not in the most efficient way
so really im after something that explores lots of commands and examples - but hopefully written in an access-able manner

any advice appreciated

Question by:malraff
    LVL 9

    Assisted Solution

    Beginning T-SQL with Microsoft SQL Server 2005 and 2008 - wrox
    LVL 22

    Accepted Solution

    How about:
    "SQL Cookbook" from O'Reilly
    "Guru's Guide to T-SQL" by Ken Henderson

    Author Comment

    Read that one already radcaesar!
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    LVL 1

    Assisted Solution

    I have SQL bible, it includesSQL for Oracle  IBM DB2, and Microsoft SQL Server 2008, very nice author, very clear, hope that helps

    Publisher: John Wiley & Sons; 2nd Edition edition (4 April 2008)

    ISBN-10: 0470229063
    ISBN-13: 978-0470229064

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now