Friday, March 9, 2012

Error 409: The assignment operator operation could not take a text data type as an argumen

How can I make it work when I need to pull out a field which is text type using a stored procedure? Please help!!!Thanks
I am getting the following error
Error 409: The assignment operator operation could not take a text data type as an argument
===========my sp=================================
CREATE PROCEDURE [dbo].[sp_SelectABC]
(@.a varchar(50) output,
@.b text output
)
AS
set nocount on
select @.a=name, @.b= description from ABC

GONo, you can't do that.

You're going to have to replace it with

select name, description from ABC

No comments:

Post a Comment