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.