MSSQL Transact-SQL 扩展插件分批删除多条

1.拼接要分批删除的ID

DELETE FROM A

FROM A AS spqh WITH(NOLOCK)
INNER JOIN (SELECT '672998' AS ID UNION SELECT '672997' UNION SELECT '672996') AS sp

ON spqh.ID = sp.ID

2.根据条件分批删除

DELETE FROM A
FROM A WITH(NOLOCK) WHERE CreateDT<DATEADD(dd,-30,GETDATE())

3.使用TOP批量删除

DELETE TOP (100) FROM A WHERE CreateDT<DATEADD(dd,-20,GETDATE()) AND OrderStatus=2