TA貢獻(xiàn)1873條經(jīng)驗(yàn) 獲得超9個(gè)贊
declare @sql varchar
set @sql='select * from t where xxx in('+@invalue+')'
exec @sql
TA貢獻(xiàn)2019條經(jīng)驗(yàn) 獲得超9個(gè)贊
declare @a varchar(10)
declare @b varchar(10)
。。。where id in(@a,@b)
TA貢獻(xiàn)1712條經(jīng)驗(yàn) 獲得超3個(gè)贊
這樣會(huì)出錯(cuò)：Conversion failed when converting the varchar value '275,276' to data type int.
TA貢獻(xiàn)1848條經(jīng)驗(yàn) 獲得超6個(gè)贊
舉報(bào)