CODEWITHSUNDEEP
sql-serverintvarchar
Doni
Doni

Reputation: 1

Conversion failed when converting the varchar value '****' to data type int

I am using Stored Procedure in Sql Server 2005.

I am getting this error:

"Conversion failed when converting the varchar value 'My_41.png' to data type int."

imageID is declared as varchar(300) in tbl_itemImage @ReturnValue is declared as varchar(MAX)

Insert and Update Query executed well, and Data is also Stored in Table. But at the end when SELECT Query is executed it gives me an above error.

This is my STORED PROCEDURE

insert into 
tbl_itemImage(itemID,imageID,name,isCoverImage,createdBy,createdOn)
values      
(@itemID,@imageID,@name,@isCoverImage,@ID,getdate())  



update tbl_itemImage
set imageID =  @imageID + CAST(@@Identity as varchar(10))+ @imageExtension
where   itemimageID = @@Identity  AND imageID <> '' 


DECLARE @ReturnValue  varchar(MAX)

select @ReturnValue = imageID from tbl_itemImage where itemImageID  = @@Identity 

Return  @ReturnValue

Upvotes: 0

Views: 3485

Answers (1)

Russell Hart
Russell Hart

Reputation: 1851

The value returned by RETURN statement(msdn.microsoft.com/en-us/library/ms174998.aspx) should be INT not VARCHAR(MAX). Instead, please use OUTPUT parameters (msdn.microsoft.com/en-us/library/ms187926.aspx). Anyway, RETURN IntValue should be used to return an error code

by Bogdan Sahlean

Should be as an answer.

Upvotes: 2

Related Questions