Declare @sql Varchar(8000)
Set @sql=''
Select @sql= @sql+','+RealName From tb_Staff Where Staff_ID In(45,46,48)select Stuff(@sql,1,1,'') as aa
我想让Staff_ID In(45,46,48) ,Staff_ID In()里面传参数怎么改啊
Set @sql=''
Select @sql= @sql+','+RealName From tb_Staff Where Staff_ID In(45,46,48)select Stuff(@sql,1,1,'') as aa
我想让Staff_ID In(45,46,48) ,Staff_ID In()里面传参数怎么改啊
set @para='45,46,48'Select @sql= @sql+','+RealName From tb_Staff Where charindex(','+ltrim(Staff_ID)+',',','+@para+',')>0select Stuff(@sql,1,1,'') as aa