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.
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?