8060 bytes is max per row, if you use NVARCHAR then 50%

KM

----- Original Message -----
From: "ikke ikke" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, August 30, 2002 9:20 PM
Subject: SQL caractere limit


> HI;
> 7,2000
> We have problem, about a limit of sql server limit row fill
>
> When we declare table with 4 field varchar(2000).
>
> What is the maximum sql limit. if i fill all row with maximum
>
> V1 Varcahr(2000)
> V2 Varcahr(2000)
> V3 Varcahr(2000)
> V4 Varcahr(2000)
> in the same table
> I fill all this row in maximum,
> My question: if SQL support the maximum if i fill this row in maximum
>
> 2000+2000+2000+2000
> in unicode caractere
>
> Help pls
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
>
MS Sql Server LazyDBA home page