开发者

Sql Server Varchar(max) and Text Data Types

开发者 https://www.devze.com 2023-04-07 15:40 出处:网络
I am researching varchar(max) data type in sql server and I try to compare with text and varchar(8000) datat开发者_运维问答ype. I read several articles about this. As specified in some articles, we ca

I am researching varchar(max) data type in sql server and I try to compare with text and varchar(8000) datat开发者_运维问答ype. I read several articles about this. As specified in some articles, we cannot update text column using regular DML statements and instead we need to use updateText, readText, writeText. I tried this in sql server 2008 and I can update text column using reqular DML statements.I wonder, was the situation that specified in articles correct for previous versions of Sql Server? And how does sql server store varchar(max) data if exceeds 8 kb?


Text datatype is available still just for backwards compatibility. Do not use it, instead use char/varchar/nchar/nvarchar in its place.

As the the limit of varchar it is 2GB.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号