Did You Know…These Data Types are Deprecated in SQL Server

This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight finding about it in a line or two.

Text, NText and Image data types have been deprecated in SQL Server since its 2012 version. Instead, it is recommended to use VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) data types