Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shobhaaradhya
Starting Member
37 Posts |
 Posted - 2014-07-07 : 06:09:10
|
| Hi, I am trying to post a string (xml) to an url EXEC @nval = sp_OAMethod @bj, 'send', NULL, @myString where I have declared @mystring as declare @mystring varchar(8000) and I am trying to create @mystring using data from a table at runtime where the @mystring value will exceed more than 8000 character and the string is truncating after character limit.Is there anyway where I can post the large file content either by storing the content in a variable or posting the file itself fetching from some location?I am doing this in sql server 2000.Thanks in advance. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-07-10 : 07:52:34
|
| use datatype varchar(max) |
 |
|
|
|
|
|
How to post XML to url