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