解决方法@H_403_8@
没有.
你想要一个DELETE与WHERE子句：这是标准的sql.
你可以做的是批量删除,如下所示：
SELECT 'Starting' --sets @@ROWCOUNT
WHILE @@ROWCOUNT <> 0
DELETE TOP (xxx) MyTable WHERE ...
或者,如果要删除非常高百分比的行…
SELECT col1,col2,... INTO #Holdingtable
FROM MyTable WHERE ..opposite condition..
TRUNCATE TABLE MyTable
INSERT MyTable (col1,...)
SELECT col1,... FROM #Holdingtable
你想要一个DELETE与WHERE子句：这是标准的sql.
你可以做的是批量删除,如下所示：
SELECT 'Starting' --sets @@ROWCOUNT
WHILE @@ROWCOUNT <> 0
DELETE TOP (xxx) MyTable WHERE ...
或者,如果要删除非常高百分比的行…
SELECT col1,col2,... INTO #Holdingtable
FROM MyTable WHERE ..opposite condition..
TRUNCATE TABLE MyTable
INSERT MyTable (col1,...)
SELECT col1,... FROM #Holdingtable
