June 22, 2006 at 3:25 pm
Guys I have already begun learning SQL Server and have created a database with code. But what i need to learn is T-SQL. I can't find any good books. I need to be able to create store procedures and functions etc.
Any book recommendations. I got the T-SQL Guru book but that book is too concise. It assumes you know stuff that i don't. I'm tired of going in circles. I have Learning SQL Server 2000 in 21 days and SQL Server Bible. They are good books. But i want to learn how to do T-SQL. I've read what these books have to say but i need more than something brief. I haven't really seen any examples using this language.
Is learning to do stored procedures all the programming i need to know?
Many people prefer it over Functions and triggers and views. Maybe i need to look for books on how to create stored procedures and not T-SQL which is the broader subject. Do i really need to know how to create UDFs, temp tables, triggers, views, etc?
I really like SQL Server but going deeper seems difficult. I haven't seen any practical books. Or anything on best coding practices. Any book suggestions? Please help! This is frustrating and i've been in the same spot for months.
Thanks!
June 22, 2006 at 3:48 pm
I believe you need a firm grounding in SQL before moving into writting SPs, maybe look at the book SQL Queries for mere mortals, less about SQL Server and more about the language you talk to it.
June 23, 2006 at 3:03 am
The ONE and ONLY book for me was the Wrox Professional SQL Server 2000 by Patrick Vieira
... superb.. explains everything... great sections on UDF's and Stored Procedures..
You DO need to know about all the other stuff (Views, triggers, etc etc) in order to make useful stored procs and you can find all that stuff explained really well in this book too.
Its a huge book.. its a big subject.. but I just found that Vieira has a really good writing style and explains things really well... persevere with that book and you'll know your stuff...
HTH
June 23, 2006 at 6:22 am
A good book for someone starting out with T-SQL is Murach's SQL for SQL Server. It's written from the point of what a developer needs to know about T-SQL.
June 23, 2006 at 7:13 am
Thanks guys! This is great help.
I already know SQL. I need to learn T-SQL.
Thanks. I will look at these books and buy them.
June 23, 2006 at 8:29 am
Hi,
I feel SQL Bible has a lot of info on T-SQL. There are chapters dedicated to SELECT, UPDATE, INSERT, DELETE statements, JOINS.
And then there are chapters on Triggers,SP,Views, I mean every aspect of T- SQL is covered in this book.
Thanks and regards,
Pradeep.N
June 23, 2006 at 9:27 am
I have found the internet to be my best resource for learning T-SQL. I will identify the command I need to use in some code and google t-sql 'command' syntax. I have yet to run into a t-sql command that I could not get information on it's use from the internet. Have fun with arrays, or lack there of in T-SQL, there's even functions for that.
June 23, 2006 at 11:03 am
Best place of all......use the SQL Server Books OnLine.
BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
or online at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp
-SQLBill
June 23, 2006 at 7:26 pm
Beginning Transact-SQL, Turley & Wood, Wrox
doco
xlseer.com
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply