SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Dynamic Sql problem.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aex
Yak Posting Veteran

60 Posts

Posted - 07/18/2006 :  23:17:33  Show Profile  Reply with Quote
I have problem in building dynamic sql. Because my query string is more than 8000 characters, so when I try to execute the dynamic sql string, sql server complaints:

String or binary data would be truncated.

How to solve this problem?

Thanks in advance for any reply.

aex

khtan
In (Som, Ni, Yak)

Singapore
17438 Posts

Posted - 07/18/2006 :  23:22:52  Show Profile  Reply with Quote
see here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=execute,dynamic,sql,more,than,8000


KH

Go to Top of Page

aex
Yak Posting Veteran

60 Posts

Posted - 07/19/2006 :  01:55:25  Show Profile  Reply with Quote
Hi khtan, really thank you for the useful thread. It helps.

aex
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000