January 3, 2012 at 7:40 am
Does anyone KNOW of a good book/s out there that teach Stored Procs from the ground up. I've done lots of general queries over the years -- self-taught in Oracle, primarily -- but, now using SQL Server 2005 .... and the company isn't going to change anytime soon!
I need a book/s (old or new, don't care) that can start from the beginning of SQL Server 2005 Stored Procs and goes step by step. Presumptions on the Author's part will "not" help.
Appreciate your candor and suggestions.
Happy New Year!
January 3, 2012 at 7:56 am
They really aren't that different than procedures in Oracle. There are a few syntax differences but the concepts are 100% the same.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 3, 2012 at 8:10 am
However reading from a book or having a guide is always good idea but I am differing for a moment. You said you learned Oracle yourself (Bravo!) so I believe you can do it again for SQL Server. This time it would be easy because many complexities that Oracle have in its implementation / architecture that SQL Server doesn’t have. Also, as Sean has already explained, only syntaxes change, rest of the stuff (more or less) same.
Another piece of advice, please focus on latest versions of SQL Server (2008 or higher)
It’s a tested (& proven) way of learning SQL Server T-SQL for Oracle guys (me too).
Best Wishes for your SQL study!
January 3, 2012 at 9:18 am
Sean & Dev,
Thanks for the advice on 2008.
I'm afraid I didn't make myself clear... I taught myself to SQL*Plus/T-SQL (gueries).
Now I work for a Company that uses SQL Server 2005 and need to learn Stored Procedures, which I've not used before.
I'm looking for actual books that can teach me the S/Procs from the ground up.
January 3, 2012 at 9:38 am
Ever done any programming? A stored procedure is just a method. It takes in some parameters (optionally), performs some work, and returns something (optional). Any books I would have used to learn this would be way out of date by now (except that the concepts are the same). You could probably just search on amazon for sql server stored procedures and find hundreds of books on the topic. Stored procs will be covered (at least at some level) in any introductory sql server book that is worthy of being in print. Find one with good reviews in a book series you like and you should be well on your way.
I know the topic can be a bit overwhelming at first glance but it really is not too bad. You were able to teach yourself pl/sql you can surely grasp stored procs pretty quickly. Just don't over complicate it. Keep it simple. Feel free to post questions on here with specifics as you run into them.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 3, 2012 at 9:47 am
There's a lot of differences between Oracle's pl sql and SQL Server's T-SQL. Not just in syntax, but in the best way to approach problems.
I recommend Itzik Ben Gan's T-SQL Fundamentals book. There's probably no better guide for getting started with T-SQL than that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2012 at 9:49 am
Actually, I taught myself queries in sql*plus, I never did programming in pl/sql. I haven't programmed in anything except in Basic/Cobol and that was 35 years ago. However, you do bring up some very good points. You've given me a huge hint with the 'SQL Server' --to me, a server is a piece of h/w, so I need to drop that concept with this subject, massive thanks. Gale
January 3, 2012 at 10:16 am
Gail,
I cannot thank you enough. That book used to sell for over $100, just got it for $14 ! It was like a needle in a haystack when I went searching - esp when I didn't really know what to look for. Your suggestion was so helpful. Gale
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply