Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to execute A Large (>4000 char) unicode statement using
Message
From
29/04/2004 15:15:25
Mark Mcneil
Solutions Technology Group
Martinsville, Virginia, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Need to execute A Large (>4000 char) unicode statement using
Miscellaneous
Thread ID:
00899484
Message ID:
00899484
Views:
46
I have a large statement @SQL that can dynamically grow up to about 6000 characters.

I need to execute this statement using :

sp_executesql

since the stored procedure parameter accepts only a single variable and the + operator is not allowed, how can I execute this statement using this stored procedure?
Next
Reply
Map
View

Click here to load this message in the networking platform