STORED PROC to "UPDATE" ntext field -- PLEASE!

[KathyB]

Hi, I've been reading all sorts of info on the ntext field. I need
this to store xml documents in sql server via a stored proc.

Because of its size, I apparently can not use SET (as in UPDATE)
therefore I'm trying to do an INSERT of the row with this field (after
deleting the old row).

CREATE PROCEDURE dbo.UpdateXmlWF
(
@varWO varchar(50)
@strWF ntext
@varCust varchar(50)
@varAssy varchar(50)
)
AS

INSERT INTO tblWorkOrders (WorkOrder, Customer, Assy, xmlWF) VALUES
(@varWO, @varCust, @varAssy, @strWF)

I'm using MSDE so I can't tell what's wrong...it just won't save the
proc.

PLEASE HELP!

Thanks, Kathy

[Erland Sommarskog]

KathyB (Ka**********@attbi.com) writes:

Because of its size, I apparently can not use SET (as in UPDATE)
therefore I'm trying to do an INSERT of the row with this field (after
deleting the old row).

CREATE PROCEDURE dbo.UpdateXmlWF
(
@varWO varchar(50)
@strWF ntext
@varCust varchar(50)
@varAssy varchar(50)
)
AS

INSERT INTO tblWorkOrders (WorkOrder, Customer, Assy, xmlWF) VALUES
(@varWO, @varCust, @varAssy, @strWF)

I'm using MSDE so I can't tell what's wrong...it just won't save the
proc.

And the error message is?
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Kathy Burke]

There wasn't an error message SQL just wouldn't let me save the stored
proc.

HOWEVER, even though I'm going to look really stupid, I'm going to now
ADMIT what was wrong!

I forgot to put the commas between the parameter variables...hope this
help someone else some day.

Kathy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!