22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE sp_DeleteAllData
AS
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'
EXEC sp_MSForEachTable 'DELETE FROM ?'
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'
EXEC sp_MSFOREACHTABLE 'SELECT * FROM ?'
GO
CREATE PROCEDURE sp_DeleteAllData
AS
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'
EXEC sp_MSForEachTable 'DELETE FROM a'
EXEC sp_MSForEachTable 'DELETE FROM b'
EXEC sp_MSForEachTable 'DELETE FROM c'
EXEC sp_MSForEachTable 'DELETE FROM d'
......
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'
EXEC sp_MSFOREACHTABLE 'SELECT * FROM ?'
GO
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'
EXEC sp_MSForEachTable 'DELETE TABLE ?', @whereand='and o.name<>''aa''';
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'
EXEC sp_MSFOREACHTABLE 'SELECT * FROM ?'
EXEC sp_MSForEachTable 'TRUNCATE TABLE ?', @whereand='and o.name<>''A''';
EXEC sp_MSForEachTable
@command1='ALTER TABLE ? NOCHECK CONSTRAINT ALL',
@command2='ALTER TABLE ? DISABLE TRIGGER ALL';
EXEC sp_MSForEachTable
@command1='TRUNCATE TABLE ?', @whereand='and o.name<>''A''';
EXEC sp_MSForEachTable
@command1='ALTER TABLE ? CHECK CONSTRAINT ALL',
@command2='ALTER TABLE ? ENABLE TRIGGER ALL';