SQL SERVER 小技巧

时间:2022-12-08 22:02:08

SQL SERVER 小技巧(不用exec实现in()的功能)

declare @x varchar(20)
SET @x='1,2,3'
SELECT @x
select * from data0001 where charindex(','+ltrim(rkey)+',',','+@x+',')>0
--======================

SQL SERVER 小技巧(多行数据转字符串a,b,c...的写法)

declare @Colstr varchar(max)
select @Colstr = isnull(@Colstr + ',' , '' ) + isnull(name , '' )  
from sys.columns WHERE object_id = OBJECT_ID('tablename')
select @Colstr as Colstr