存储过程的问题
假如有张表
id (int primary key) name(nvarchar)
1 xiao111
2 xiao222
3 xiao333
4 xiao444
函数Delete(int[] ids) 我传入 数组{1,3,4} 函数内部调用存储过程 把1, 3 ,4的记录 删掉
请问 这个存储过程怎么写??
实现的思想是什么?
[解决办法]
ALTER PROCEDURE [dbo].[TRYINA]
-- Add the parameters for the stored procedure here
(@ZZ CHAR(10))
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
DELETE FROM ZW1..AA1 WHERE CHARINDEX(CAST(ID AS VARCHAR(10)),@ZZ)>0
END
EXEC TRYINA '1,3,4'
[解决办法]
DELETE FROM ZW1..AA1 WHERE CHARINDEX(','+CAST(ID AS VARCHAR(10))+',',','+@ZZ+',')>0