Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

SQL server :Use variable to hold string of size greater than 8000.

Home
Forums

SQL server :Use variable to hold string of size greater than 8000.

Pravin More

15yAsked Aug 26, 2011, 2:35 AM3.1k

Hello All,

I am using SQL Server 2008. In my Sproc i am taking big sql query in nvarchar(max) type variable and execute it with exec....but the problem is that its exceeding limits and i am not able to execute whole query.my query size is 9778.

help me if you know the solution for this problem.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Pravin More15y ago
hi...for now i took that query in c# instead of sproc n it worked.
ya even i think there might be some syntax error but due to lack of time i executed it from c# code.

thanx suthish for your help.

Pravin.
Suthish Nair15y ago
Resolved? check for spaces between statements etc..
Suthish Nair15y ago
send me on mail..
Pravin More15y ago
Thanks suthish. but i can't paste sproc code
Suthish Nair15y ago
Post/attach your SP here.
Pravin More15y ago
yes suthish, i printed query but its able to print only half part because of limit and therefore i am getting error is "Incorrect syntax near".
Suthish Nair15y ago
Then it might be different problem. Are you able to print the sql statements ("print @sqlquery"). fire/execute the query in new window.. what exact error you getting?
Pravin More15y ago
Thank you suthish for reply.i tried varchar(max) too but its not working.
Suthish Nair15y ago
change the datatype to varchar(max) or nvarchar(max). use varchar(max).