常用存储过程

declare  @Mark varchar(1)
declare @userids varchar(max)
declare @FileName varchar(100)
set @FileName ='Usernames'
set @userids =''''+'bichongjun'+''''+','+''''+'caobin'+''''
print(@userids)
set @Mark =','
declare @Ruturn nvarchar(max)
  set @Ruturn= ' declare @usernames nvarchar(max)
  set @usernames=''''
  select @usernames=case when @usernames='''' then username else (@usernames+'''+@Mark+'''+username) end from [SDMS_User] where [UserID] in ('+@userids+')
  select @usernames as '+@FileName+'' 
  print(@Ruturn)

 

表量函数主要是用是字符串的拆分，这种类型的SQL还是在数据库中写好查询语句再来拼最好