SQL Server 2018 Deprecated Features List

TEXT, NTEXT, and IMAGE data types

Data Types

SET ROWCOUNT for DML

Session Options

TIMESTAMP syntax for CREATE TABLE

Creating Tables

DBCC DBREINDEX, INDEXDEFRAG, and SHOWCONTIG

Maintenance Plans

Old SQL Mail

Database Mail

IDENTITY seed, increment, non primary key, and compound

Sequences and Identity

Stored procedures RETURN values

Stored Procedures

GROUP BY ALL, Cube, and Compute By

GROUP BY

DTS

ETL

Old outer join syntax = and =

Table JOIN

'String Alias' = Expression

Migration Quick Tips

DEFAULT keyword for INSERT statements

Migration Quick Tips