方法一 分割例:通过SQL Server存储过程传送数组参数删除多条记录 eg. ID 值为'1,2,3' 以下存储过程就是删除表中id号为1,2,3的记录:CREATE PROCEDURE DeleteNews @ID nvarchar(500) as DECLARE @PointerPrev int DECLARE @PointerCurr int DECLARE @TId int Set @PointerPrev=1 while (@PointerPrev < LEN(@ID)) Begin Set @PointerCurr=CharIndex(',' Read More
posted @ 2011-11-10 11:27 咸鱼公子 Views(21169) Comments(1) Diggs(0) Edit