Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Suggestion for learning SQL Server 2008

Author  Topic 

varunprasadyg
Starting Member

3 Posts

Posted - 2013-09-23 : 06:07:13
Hello,

I am an Oracle Developer having spent several years completely in that product.I am quite comfortable with Oracle but in our new project I have been asked to maintain numerous SQL Server 2008 Stored procedures.

Upon taking a look at that code I am able to vaguely understand what they do but I am not at all comfortable.
SQL Server syntax is different than that of Oracle.

Can anyone suggest me a resource (book or website) which teaches SQL Server Programming (stored procedures) for someone who already knows SQL ?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-23 : 08:37:25
I am a fan of Itzik Ben-Gan's books on T-SQL. I would start with this book : http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145/ref=la_B001IGQENW_1_2?s=books&ie=UTF8&qid=1379939732&sr=1-2

Even though the title says Fundamentals, it is a pretty good book that covers many of the commonly used aspects of T-SQL programming. Ben-Gan also has two other books SQL 2008 programming and SQL 2008 querying, that go more in depth and are quite good too. Don't let the version of SQL Server (2008) stop you from considering those books. They are relevant and good even now.
Go to Top of Page

varunprasadyg
Starting Member

3 Posts

Posted - 2013-09-23 : 08:57:09
quote:
Originally posted by James K

I am a fan of Itzik Ben-Gan's books on T-SQL. I would start with this book : http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145/ref=la_B001IGQENW_1_2?s=books&ie=UTF8&qid=1379939732&sr=1-2

Even though the title says Fundamentals, it is a pretty good book that covers many of the commonly used aspects of T-SQL programming. Ben-Gan also has two other books SQL 2008 programming and SQL 2008 querying, that go more in depth and are quite good too. Don't let the version of SQL Server (2008) stop you from considering those books. They are relevant and good even now.



Thanks for helping.
I will go through the fundamentals first and go from there :)
Go to Top of Page
   

- Advertisement -