ALTER PROC [dbo].[getTriggerNamesbyId] 
           @id INT,
           @returnval NVARCHAR(500) OUTPUT
AS 
BEGIN 
    SET @returnval = (SELECT TriggerPointDescription 
                      FROM ClaimTriggerInfo 
                      WHERE TriggerPointID=@id ) 
    RETURN (@returnval) 
END

Above is my stored procedure but when i pass valu it give me errror such as (Msg 245, Level 16, State 1, Procedure getTriggerNamesbyId, Line 12 Conversion failed when converting the nvarchar value 'sfdajfr' to data type int.) then how it possible

Submitted under: Microsoft SQL Server ·  ·  ·  ·