存储过程带in参数

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[TestList]
 @UserID nvarchar(4000)

AS

DECLARE
 @search_array nvarchar(100)
BEGIN

 

set @search_array ='16,17,18,19' 
select * from Users where charindex(','+rtrim([User_ID])+',' , ','+ @UserID +',')>0

--  set @search_array= '''' + replace(@UserID,',',''',''') + '''';
--  Select * From Users Where  [User_Name] in (@search_array);

 

END