by 
yangjian
ANSWERS: 1
-
The text datatype is actually set to be retired in future versions of SQL. But, as of v2005, it is still being used. Basically, it is a larger datatype that can hold 2,147,483,647 characters in a field. Although, varchar(max) can also hold that many characters as well. Text datatypes will be smaller to store than varchar(xxx) types, but this comes with a performance hit to the server.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC