CREATE Procedure p_Test
@deptno varchar(50)
AS
--set @deptno = '0102, 0103, 0107'
Select * from Bdepart WHERE charindex(', '+DeptNo+',',', '+@deptno+',')>0
@deptno varchar(50)
AS
--set @deptno = '0102, 0103, 0107'
Select * from Bdepart WHERE charindex(', '+DeptNo+',',', '+@deptno+',')>0
CREATE Procedure p_Test
@deptno varchar(50)
AS
--set @deptno = '''0102'', ''0103'', ''0107''' --注意赋值方法
exec(' Select * from Bdepart WHERE WHERE DeptNo in ('+@deptno+')')
@deptno1 varchar(50),
@deptno2 varchar(50),
@deptno3 varchar(50)
AS
set @deptno1 = '0102'
set @deptno2 = '0103'
set @deptno3 = '0107'
Select * from Bdepart WHERE DeptNo in (@deptno1,@deptno2,@deptno3)