sql - Implicit conversion from int to varchar -
set @waveperiod = convert ( varchar,@value ) + convert (varchar,@value2) is valid sql statement in procedure ?
@waveperiod varchar(20)
@value , @value2 int
i getting error message: implicit conversion int varchar
it's valid syntax in sybase ase, see below. did not specify actual database other 'sybase' in tag'...
declare @waveperiod varchar(20) declare @value int, @value2 int set @value = 123 set @value2 = 456 set @waveperiod = convert ( varchar,@value ) + convert (varchar,@value2) select @waveperiod result: -------------------- 123456
Comments
Post a Comment