首先創建一個分隔字符串函數：

 1 create  function  SplitIn(@c   varchar(2000),@split   varchar(2))   
 2 returns   @t   table(col   varchar(20))   
 3 as   
 4 begin    
 5   while(charindex(@split,@c)<>0)   
 6     begin   
 7       insert   @t(col)   values   (substring(@c,1,charindex(@split,@c)-1))   
 8       set   @c   =   stuff(@c,1,charindex(@split,@c),'')   
 9     end   
10   insert   @t(col)   values   (@c)   
11   return   
12 end

第二，在存儲過程中使用SplitIn函數

1 select @TeamRoomCount = COUNT(Work_GuestAccount.AccountID)  FROM  Work_GuestAccount INNER JOIN 
2                 Work_GuestEntryIndex ON Work_GuestAccount.EntryID = Work_GuestEntryIndex.EntryID 
3                 WHERE (Work_GuestEntryIndex.TeamID <> '') AND (Work_GuestEntryIndex.TeamID IS NOT NULL)
4                 AND (Work_GuestAccount.RoomID IN (select col from SplitIn(@TeamRoomNo,',')))

轉載于:https://my.oschina.net/u/2607133/blog/599007

總結

以上是生活随笔為你收集整理的Sql server 使用 in()函数 传递字符串的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。