Comment Feed for Stored Procedure (TechOff on Channel 9)

Re: Stored Procedure

VBJB — Wed, 20 Dec 2006 18:37:18 GMT

This works:

Set @NewComment = (Select Cast(Delivery.Comment as varchar(250)) From Delivery Where Delivery.ID = 50)

Re: Stored Procedure

VBJB — Wed, 20 Dec 2006 17:25:18 GMT

I tried this and I get the same error:

Declare @NewComment varchar(250)

Set @NewComment = Cast((Select Delivery.Comment From Delivery Where Delivery.ID = 50) as varchar(250))

Re: Stored Procedure

Matthew van Eerde — Wed, 20 Dec 2006 17:20:35 GMT

There's UPDATETEXT, but it's not especially easy to use. If you're certain the text is less than 8000 characters, you can cast it to a varchar.