-
May 5th, 2004, 02:07 AM
#1
Packet size
How can I sent in a single sql statement a string with more than 30000 chars. I incresed "Packet size" prop from SQL Server to 35000, but no result.
Thanks.
-
May 5th, 2004, 03:25 AM
#2
Hi
I don't know a solution for the packet size problem..
but i think you have a big problem with the database design..
such large queries sould be stored in the database as stored procedurs..
this will :- Decrease network traffic.
- Increase DB performance as the Prcedure will be compiled and cached.
- Improve the readability of your application.
-
May 5th, 2004, 05:20 PM
#3
Send it through as a blob (use BlobToFile & FileToBlob, or stream methods) If you search here using those as keywords, you should find the correct code to do what you want.
Be nice to Harley riders...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|