Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
How to execute dynamic query having length > 8000 bytes
Liladhar Nimje
May 6 2016 8:01 AM
368
Reply
Hi,
I am executing a query using "Exec (@Query)" syntax, where @Query is having length greater than 8000 bytes in size. So when I am trying to execute this query, it is not going to execute whole query and giving error.
I have a Eg for that,
Declare
@a Varchar(8000),
@b Varchar(8000);
Select
@a = ' ', -- @a contains insert query
@b = ' '; -- @b contains where clause
Execute (@a + @b)
Thanks for your help in advance!!!
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Stored Procedure From Scratch. Syntax, Rules & Generalisatio
Database backup