i think its something like this
varchar - variable length character string (max 8000 characters)
text - variable length text (max 2^31 -1 characters)
int - range from -2^31 through 2^31-1
bigint - range from -2^63 through 2^63-1
smallint - range from -2^15 through 2^15-1
tinyint - range from 0 to 255
On 4/26/05, sas0riza <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> Does anyone know if there are any restrictions in MS SQL Server that
> would limit the length of the fields? Is there a max length for each
> column/field? Or is it dependent upon the datatype?
>
> Thanks!!
>
>
> Yahoo! Groups Links
>
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
