Functions deprected after SQL Server 2008

Deprecated Option in SQL Server 2008

Some features are deprecated from next version of SQL Server 2008, here are some of the commons used functions which are deprecated and their replacements.
Look at BOL for more info



sp_dboption

This feature will not be supported in next version of SQL Server. Use Alter Database instead of this.

*= and =*
These are non Ansi syntax for table joins , use regular Ansi Sytax like left join or right join.

Databaseproperty
Databaseproperty will be replaced by DatabasepropertyEx


Compability levels :- Compability levels 80 and 90 , levels from last 2 versions only will be supported.


SET ROWCOUNT for INSERT, UPDATE, and DELETE statements
Use TOP (n) for instead of ROWCOUNT for this statements.

Compute /Compute By
:- Use ROLLUP instead of this functions.

No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts