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