Recommended reading for basic stored proc T-SQL?

Christopher Duncan

SSC Veteran

Points: 275
More actions
February 9, 2009 at 6:27 am

#201046

Hey, guys.
There are countless books out there on stored procs, etc. but all that I've seen tend to either focus on querying or go off on various tangents without thoroughly addressing the basics of the programming language (control flow, variables, system routines, etc.).
I've been a developer for 20 years and have been working with databases from that side of the street for about as long. However, I've never really delved into learning the programming side via stored procs, triggers, functions, etc. While I've written plenty, I've always just been a hack at it. I'd really like to start with a beginner's mind and take the language start to finish just as I would C, C#, and so on.
Do any of you have recommendations on this kind of reading, be it books, white papers, online articles, etc? There's a lot of good stuff here, of course, but once again it tends to be topical rather than tutorial as far as a comprehensive review of the basics go.
Thanks,
Chistopher Duncan
Author of (Apress) The Career Programmer
Unite the Tribes (Apress)

Viewing 7 posts - 1 through 6 (of 6 total)

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

steveb. SSC-Forever Points: 46733 More actions · Answer 1

I think that the Inside Microsoft SQL Server series by Itzik Ben-Gan are some of the best books around for learning the fundamentals of SQL programming.

http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2005/dp/0735621977/ref=sr_1_1?ie=UTF8&s=books&qid=1234187520&sr=8-1%5B/url%5D

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

As the author I think this article is a good starting point for triggers, http://www.sqlservercentral.com/articles/Triggers/64214/. Beyond that shameless plug, I also think BOL is under utilized resource for these types of things

Here's a link to some resources regarding stored procedures, http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1247499,00.html?track=sy41#

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

D.Oc SSCrazy Points: 2875 More actions · Answer 3

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL And .NET

http://www.amazon.com/Microsoft-Server-Stored-Procedure-Programming/dp/0072262281

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 4

Hi

Check out the below links

http://www.dotnetspider.com/tutorials/

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Christopher Duncan SSC Veteran Points: 275 More actions · Answer 5

steveb (2/9/2009)

I think that the Inside Microsoft SQL Server series by Itzik Ben-Gan are some of the best books around for learning the fundamentals of SQL programming.

http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2005/dp/0735621977/ref=sr_1_1?ie=UTF8&s=books&qid=1234187520&sr=8-1%5B/url%5D%5B/quote%5D

Hi, Steve.

Thanks for taking the time. In fact, I have this book and it's an excellent example of a high quality book, but one that doesn't address the basics, which you can get a feel for from the TOC:

[url]http://www.amazon.co.uk/gp/reader/0735621977/ref=sib_dp_bod_toc/279-1341378-9866226?ie=UTF8&p=S006#reader-link"> http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2005/dp/0735621977/ref=sr_1_1?ie=UTF8&s=books&qid=1234187520&sr=8-1%5B/url%5D%5B/quote%5D

Hi, Steve.

Thanks for taking the time. In fact, I have this book and it's an excellent example of a high quality book, but one that doesn't address the basics, which you can get a feel for from the TOC:

http://www.amazon.co.uk/gp/reader/0735621977/ref=sib_dp_bod_toc/279-1341378-9866226?ie=UTF8&p=S006#reader-link

If I'd never seen a stored proc in my life and wanted to know about control flow, variables, standard system library routines, etc. this wouldn't be the first book to read.

Great stuff, but I'm looking to go back to the basics and learn them both properly and comprehensively. 🙂

Chistopher Duncan
Author of (Apress) The Career Programmer
Unite the Tribes (Apress)

Christopher Duncan SSC Veteran Points: 275 More actions · Answer 6

Jack Corbett (2/9/2009)
As the author I think this article is a good starting point for triggers, http://www.sqlservercentral.com/articles/Triggers/64214/. Beyond that shameless plug, I also think BOL is under utilized resource for these types of things
Here's a link to some resources regarding stored procedures, http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1247499,00.html?track=sy41#

Hey, Jack.

Good stuff, and going on my reading list. Thanks!

Chistopher Duncan
Author of (Apress) The Career Programmer
Unite the Tribes (Apress)