USE [TAMS]
GO
/****** Object: StoredProcedure [dbo].[get_EmployeeID] Script Date: 04/11/2012 14:30:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[get_EmployeeID]
(
@id varchar(1024)
)
as
BEGIN
declare @sql nvarchar(2048)
SELECT * FROM Employee WHERE EmployeeID in (@id)
exec sp_executesql @sql
end
存储过程是这样写的，没有错，[email protected]，
EXEC get_EmployeeID '001','002'
EXEC get_EmployeeID '001,002'
这样查询不出来
001，002也不行
只能单独 001，或者单独002才可以查询出来，怎么办？
------解决方案--------------------
- SQL code
create proc [dbo].[get_EmployeeID] (@id varchar(1024))asbegindeclare @sql nvarchar(2048)set @sql='SELECT * FROM Employee WHERE EmployeeID in ([email protected]+')'print @sqlendgoexec get_EmployeeID '''001'',''002'''drop proc get_EmployeeID/*************************SELECT * FROM Employee WHERE EmployeeID in ('001','002')