RE: Long string passed into SQL Server Stored Procedure?

[Duane Ronan]

I figured it out.  The maximum length you can pass into a SQL Server stored
procedure is 8000 chars, so you just specify varchar(8000).  If you happen
to send in a string longer than the specification, it will be truncated,
resulting in an error.


-----Original Message-----
From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf
Of Duane Ronan
Sent: Friday, September 30, 2005 5:54 PM
To: list@dfwcfug.org
Subject: Long string passed into SQL Server Stored Procedure?

Hey Gang,

I need to pass in a long WHERE clause into a stored procedure.  The WHERE
clause is longer than 255 characters.  Is this possible?  Thanks for your
input.

Duane Ronan


----------------------------------------------------------
To post, send email to list@dfwcfug.org
To unsubscribe: 
   http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: 
   http://www.dfwcfug.org/form_MemberRegistration.cfm



----------------------------------------------------------
To post, send email to list@dfwcfug.org
To unsubscribe: 
   http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: 
   http://www.dfwcfug.org/form_MemberRegistration.cfm