34,590
社区成员
发帖
与我相关
我的任务
分享
create PROC P_Delete
AS
BEGIN
DECLARE @p_id INT
SELECT @p_id = id FROM node WITH(NOLOCK) WHERE tablename = 'source_1'
DELETE TOP(1000) depart WHERE id < @p_id
return @@ROWCOUNT
END
GO
WHILE(@@ROWCOUNT=1000)
EXECUTE P_Delete
print @@ROWCOUNT
DELETE t FROM depart t
INNER JOIN node AS n ON t.id < n.id and n.tablename = 'source_1'
一句sql就行了