操作数类型冲突:ntext与存储过程中的图像不兼容 [英] Operand type clash: ntext is incompatible with image in stored procedure

问题描述

请告诉我们如何解决存储过程中的此错误.我的更新存储过程为

Please some one tell that how to solve this error in stored procedure. My stored procedure for the update is

create proc updateproduct
(
 @id numeric(18, 0),
 @producttype nvarchar(50),
 @Image ntext
)
as 
begin
update products set producttype=@producttype ,Image=@Image where id=@id
end

它引发错误
操作数类型冲突:ntext与图像不兼容

请帮助我解决此错误.

it throwing an error
Operand type clash: ntext is incompatible with image

Please help me to solve this error.

推荐答案

producttype 表中的 image 列的数据类型不是与您在存储过程中提供的数据类型匹配.

要查看text，ntext和image数据类型之间的兼容性，请检查以下链接:
http://msdn.microsoft.com/en-us/library/aa175795 (v = sql.80).aspx [

the data type of image column in producttype table is not matching with the data type you provided in the stored procedure.

To see compatibility between text, ntext and image data type, please check the following link:
http://msdn.microsoft.com/en-us/library/aa175795(v=sql.80).aspx[^]

这篇关于操作数类型冲突:ntext与存储过程中的图像不兼容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！