stored procedure with varchar(max) output parameter

[Andrew Robinson]

I have a stored proceedure that has a varchar(max) output parameter. How do
I specify my size value in the parameters collection? or is this something
that cannot be done?

Thanks,

 

[WenYuan Wang [MSFT]]

Hi Adrew,

According your description, do you want to know how to specify the size
value in ADO.net Parameter? Please let me know if you misunderstood
anything here.

public SqlParameter (string parameterName,SqlDbType dbType,int size)
You could specify the size value of parameters.
For example:
SqlParameter paramSummary =new SqlParameter("@DocumentSummary",
SqlDbType.NVarChar,25);
paramSummary.Direction = ParameterDirection.Output;
command.Parameters.Add(paramSummary);

Additionally, you can specify the size as -1, if you don't know how length
it is.
SqlParameter paramSummary =new SqlParameter("@DocumentSummary",
SqlDbType.NVarChar,-1);

You may check the "Using Large Value Type Parameters" section in the
following document.
http://msdn2.microsoft.com/en-us/library/a1904w6t.aspx
[Working with Large Value Types]

Hope this helps. If you still have anything unclear, please feel free to
let me know.
Have a great day,
Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[WenYuan Wang [MSFT]]

Hi Andrew,

I just want to check whether the issue has been resolved. If it persists or
you still meet any futher issue, please don't hesitate to update here. I'll
follow up.

Have a great day,
Sincerely,
Wen Yuan
Microsoft Online Community Support