maxlength of parameter? 
Author Message
 maxlength of parameter?
What is the maximum length that can be passed to a stored procedure
(varchar parameter) in SQL Server 7?  Am I limited to 256 chars?

Thanks!
MJ

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 04 Dec 2002 03:00:00 GMT
 maxlength of parameter?


Quote:
> What is the maximum length that can be passed to a stored procedure
> (varchar parameter) in SQL Server 7?  Am I limited to 256 chars?

> Thanks!
> MJ

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Not at all.

I think, the limit is varchar(8000).

--
********************************************

      Dipl.-Ing. Juergen Weinmann

********************************************



Wed, 04 Dec 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. MaxLength problems

2. Headbang: Annoyed users, trailing spaces, SQL 6.5 field length, txt box, MaxLength

3. MaxLength and dates

4. change maxlength-limit of informix-views

5. Maxlength on the statement in ODBC.

6. MaxLength by TBEdit

7. COL_LENGTH and MaxLength

8. Maxlength of string in datagrid control

9. DBEdit.MaxLength and numbers

10. VFP6 Editbox MaxLength

11. MaxLength in DBGRID ?

12. Delphi 1 and 2 Tdbedit.MaxLength property


 
Powered by phpBB® Forum Software