best way to learn T-SQL

  • hi

    so i want to know what is best way to learn TSQL, like i know all functions and what it does in TSQL. but it comes to writing code like SP,
    or triggers or any queries, i dont know where to use , what to use. i want to learn advanced sql specially to write stored procedure.

    i know all simple sql and all functions , but i am not able to write SP or any code.

    how to learn it?

  • coool_sweet - Sunday, May 28, 2017 6:31 AM

    hi

    so i want to know what is best way to learn TSQL, like i know all functions and what it does in TSQL. but it comes to writing code like SP,
    or triggers or any queries, i dont know where to use , what to use. i want to learn advanced sql specially to write stored procedure.

    i know all simple sql and all functions , but i am not able to write SP or any code.

    how to learn it?

    Itzik Ben-Gan has some good books for mid-upper level TSQL stuff. Carlos Chacon just released a very good intro TSQL book.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • thanks, i will try to read it

  • TheSQLGuru - Sunday, May 28, 2017 9:23 AM

    coool_sweet - Sunday, May 28, 2017 6:31 AM

    hi

    so i want to know what is best way to learn TSQL, like i know all functions and what it does in TSQL. but it comes to writing code like SP,
    or triggers or any queries, i dont know where to use , what to use. i want to learn advanced sql specially to write stored procedure.

    i know all simple sql and all functions , but i am not able to write SP or any code.

    how to learn it?

    Itzik Ben-Gan has some good books for mid-upper level TSQL stuff. Carlos Chacon just released a very good intro TSQL book.

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

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