Important deprecated features of SQL server 2017
I was going through list of deprecated features/syntax and I am sure in all projects we are using atleast some of the below features/syntax which might break after upgrade.
- RESTORE and BACKUP database WITH PASSWORD
- Ability to return result set from triggers
- SET ROWCOUNT for INSERT, UPDATE and DELETE
- SET ANSI NULLS OFF
- Ability to insert null values into timestamp columns
- TEXT, NTEXT and IMAGE datatypes
- CREATE TABLE, ALTER TABLE or CREATE INDEX syntax without parenthesis around the option
- Lot of options of procedure sp_configure
- Specifying the SQLOLEDB provider for linked servers
- USER_ID function
- Specifying NOLOCK or READUNCOMMITTED in the FROM clause of an UPDATE or DELETE statement.
- Specifying table hints without using the WITH keyword.
- Three-part and four-part column references.
- A string enclosed in quotation marks used as a column alias for an expression in a SELECT list:
'string_alias' = expression
- SQL Server Profiler for Trace Capture
- Lot of system tables and system stored procedure like sysindexes
Source: Microsoft
No comments: