Geek asks and answers

Combine all parameters and make a string in Stored Proc?

I have parameters in SP and try to concat them for string

@OBID int,
@ODID int,
@EMID int,
@TYPE varchar(20),
@LastModifiedBy int

SET @Strcat = @OBID +','+ @CursorODID +','+@EmpName +','+@TYPE

He gives an error.

 Error Description: Conversion failed when converting the varchar value ',' 
to data type int. 1
+3
source share
2 answers

Convert all non-string variables to string and then concat ...

SET @Strcat = Convert(varchar(50), @OBID) +','+ Convert(varchar(50), @CursorODID) +','+@EmpName +','+@TYPE
+5
source

You need to convert it to nvarchar / varchar first:

@OBID int,
@ODID int,
@EMID int,
@TYPE varchar(20),
@LastModifiedBy int

SET @Strcat = CONVERT(nvarchar,@OBID) +','+ CONVERT(nvarchar,@CursorODID) +','+@EmpName +','+@TYPE

Hi

0
source

More articles:


All Articles