What is difference between varchar and varchar(max) in sql server [Resolved]

Posted by Jitendrasoft09 under Sql Server on 6/26/2013 | Points: 10 | Views : 4372 | Status : [Member] [MVP] | Replies : 3
Hi All,
I want to understand What is difference between varchar and varchar(max) in sql server, let me know if anybody knows.

Jitendra Kumar
If my post helps you, plz mark as an answer.



Responses

Posted by: perfectchourasia-9163 on: 6/27/2013 [Member] Starter | Points: 50

Up
0
Down

Resolved
Varchar : maximum storage capacity is 8000 bytes of storage
Varchar(Max) :maximum storage capacity is 2GB of storage

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Satyapriyanayak on: 6/26/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
http://sqlhints.com/2013/03/10/difference-between-sql-server-varchar-and-varcharmax-data-type/

If this post helps you mark it as answer
Thanks

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jitendrasoft09 on: 6/27/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Thanks Satya, Good explanation Chourasia..

Jitendra Kumar
If my post helps you, plz mark as an answer.

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response