IOT Virtual Conference - Register now to book your ticket and get updates
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Liladhar Nimje
2k
30
3.7k
How to execute dynamic query having length > 8000 bytes
May 6 2016 8:01 AM
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!!!
Reply
Answers (
3
)
Stored Procedure From Scratch. Syntax, Rules & Generalisatio
Database backup