what is the max and min size of varchar data type?

Posted by Deepak625 under ASP.NET on 1/10/2012 | Points: 10 | Views : 1578 | Status : [Member] | Replies : 3
what is the max and min size of varchar data type?
and when we should use varchar data type?

deepak


Responses

Posted by: Rkworlds on: 1/10/2012 [Member] Starter | Points: 25

Up
0
Down
In sql server 2008

max size of varchar data type varchar(max)
min size of varchar data type varchar(0)


In sql server 2005 / 2000

max size of varchar data type varchar(8000)
min size of varchar data type varchar(0)


if text or string formate we can use varchar

If this helps you .
Please "Mark as Answer"

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

Posted by: Sksamantaray on: 1/10/2012 [Member] Silver | Points: 25

Up
0
Down
More about Sql datatypes
:
http://databases.about.com/od/sqlserver/a/char_string.htm

Thanks,
Sanjay

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

Posted by: MBA Updates on: 1/11/2012 [Member] Starter | Points: 25

Up
0
Down
In sql server 2008

max size of varchar data type varchar(max)
min size of varchar data type varchar(0)


In sql server 2005 / 2000

max size of varchar data type varchar(8000)
min size of varchar data type varchar(0)

http://www.mbaupdates.com/index.aspx

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

Login to post response