declare @Param nvarchar(50)
select * from temp where A in (@Param)
传进来的是'1,2,3'
这样是不对的 A 是 int型
sql:select * from temp where A in ('1,2,3') 错误如何让转换成
sql: select * from temp where A in(1,2,3)除了用拼接外还有啥办法能解决呢?怎么把('1,2,3')->(1,2,3)
select * from temp where A in (@Param)
传进来的是'1,2,3'
这样是不对的 A 是 int型
sql:select * from temp where A in ('1,2,3') 错误如何让转换成
sql: select * from temp where A in(1,2,3)除了用拼接外还有啥办法能解决呢?怎么把('1,2,3')->(1,2,3)
exec ('select * from temp where A in ('+@Param+') ')
select * from temp where ','+@Param+',' like '%,'+rtrim(A)+',%'
@Sql = 'select * From temp where A in ('+@params+')'
exec (@Sql)
select @Sql = 'select * From temp where A in ('+@params+')'
exec (@Sql)