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.
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 |
|
|
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 |
|
|
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! |
|
|
mcp111
Starting Member
44 Posts |
|
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 |
|
|
|
|
|