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
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Stored procedures in SQL Server 2005

Author  Topic 

Huligan
Yak Posting Veteran

66 Posts

Posted - 2006-12-30 : 19:34:17
Hello. I'm familar with stored procedures of SQL Server 2000, but I'm building a website in ASP.NET 2.0 and want to write my stored procedures in SQL Server 2005. Does anyone know of a good "how to" reference I can review before I start writing all of my SQL Server 2005 stored procedures. I'm looking for something with some examples and maybe a comparison between 2000 and 2005. This is my first project on SQL Server 2005 and I want to make sure I take full advantage of SQL Server 2005. I also don't want to do anything deemed insecure. Thanks for your time and help.

Les

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-12-31 : 10:44:30
sprocs are same in SS2k and SS2k5.

what are you asking exactly?



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Huligan
Yak Posting Veteran

66 Posts

Posted - 2007-01-03 : 13:32:08
Maybe you answered my question. I just assumed there would be some small variances and a few new features for stored procedures in SQL Server 2005 versus 2000. If there isn't, then I'm good. Are there no changes? Not even in regard to security?

Les
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2007-01-03 : 14:30:06
All your sprocs should be backward compatible.

For new features and functions, check the "What's New" section of 2005 Books Online.

STAR SCHEMAS ARE NOT DATA WAREHOUSES!
Go to Top of Page

mcp111
Starting Member

44 Posts

Posted - 2007-01-09 : 11:00:51
Check out this book
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0470054034.html
Go to Top of Page

mcp111
Starting Member

44 Posts

Posted - 2007-01-09 : 11:01:54
Microsoft has lots of free online courses on sql server 2005.
Check out www.microsoftelearning.com
Go to Top of Page
   

- Advertisement -