June 10, 2004 at 8:24 pm
Anyone? pls pls... very urgent
June 11, 2004 at 5:19 pm
It doesn't seem to be a SQL issue, sounds like a sqloledb issue since it worked in ODBC. I don't see any obvious problems with your code, but I'm no expert.
Yukon has an xml datatype, but that doesn't help much!
Really, if you want to store a string longer than 8000 characters you need to use the "text" datatype. And you can't have a text data type variable, so using procs is out of the question.
cl
Signature is NULL
June 13, 2004 at 5:28 am
What language are you using? On SQL 2k you should be able to use a text parameter and a text column type.
June 18, 2004 at 7:42 pm
Yes, but
CREATE PROCEDURE updatePage
<snip>
@strBody text,
<snip>
AS
UPDATE Page
SET
<snip>
Page.strBody = @strBody,
<snip>
WHERE
Page.intPageId = @intPageId
GO
would (does) work fine...
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply