SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Stored procedures in SQL Server 2005
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Huligan
Yak Posting Veteran

USA
66 Posts

Posted - 12/30/2006 :  19:34:17  Show Profile
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

Slovenia
11749 Posts

Posted - 12/31/2006 :  10:44:30  Show Profile  Visit spirit1's Homepage
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

USA
66 Posts

Posted - 01/03/2007 :  13:32:08  Show Profile
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
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 01/03/2007 :  14:30:06  Show Profile
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!

Edited by - blindman on 01/03/2007 14:30:46
Go to Top of Page

mcp111
Starting Member

40 Posts

Posted - 01/09/2007 :  11:00:51  Show Profile  Visit mcp111's Homepage  Send mcp111 a Yahoo! Message
Check out this book
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0470054034.html
Go to Top of Page

mcp111
Starting Member

40 Posts

Posted - 01/09/2007 :  11:01:54  Show Profile  Visit mcp111's Homepage  Send mcp111 a Yahoo! Message
Microsoft has lots of free online courses on sql server 2005.
Check out www.microsoftelearning.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000