Obsolete T-SQL programming features in SQL Server 2008 R2
We have lots of stored procedures written in SQL Server 2005. After database migrated from 2005 to 2008 all of them seem to be functional as before. Now we need to migrate to 2008 R2. So the question I have is:
Is there any T-SQL programming features are obsolete in 2008 R2 comparing to 2005?
That's important for us to know so we can update all sprocs accordingly.
Also, is there any other im开发者_运维技巧plications for migrating from 2005 to 2008 R2 in terms of stored procedures?
I would appreciate your answer.
Thanks!
Microsoft calls this kind of thing a "Breaking Change", and publishes an article with each Sql Server release that covers all known breaking changes. The article for 2008 R2 is here:
http://msdn.microsoft.com/en-us/library/ms143179.aspx
精彩评论