可以批量删除的存储过程

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

-- =============================================

-- Author: <WXSF-HWX>

-- Create date: <20090728>

-- Description: <删除收藏>

-- =============================================

ALTER PROCEDURE [dbo].[SP_DelFavorite] 

(

@vcUserName  VARCHAR(60),    --当前用户ID

@iId  varchar(max), --收藏编号(可删除复数条)

@reValue  INT = 0 OUTPUT --返回值

)

AS

BEGIN

SET NOCOUNT ON;

--删除收藏

DELETE  FROM [dbo].[T_Favorites] 

WHERE vcUserName=@vcUserName 

AND patIndex('%,'+Rtrim(iId)+',%', ','+@iId +',')>0

END