2010. 7. 20. 10:15
ALTER TABLE [TABLE_NAME] DISABLE TRIGGER ALL
ALTER TABLE [TABLE_NAME] NOCHECK CONSTRAINT ALL
IF EXISTS (SELECT TOP 1 * FROM [TABLE_NAME])
DELETE FROM [TABLE_NAME]
ALTER TABLE [TABLE_NAME] DISABLE TRIGGER ALL
ALTER TABLE [TABLE_NAME] NOCHECK CONSTRAINT ALL
ALTER TABLE [TABLE_NAME] NOCHECK CONSTRAINT ALL
IF EXISTS (SELECT TOP 1 * FROM [TABLE_NAME])
DELETE FROM [TABLE_NAME]
ALTER TABLE [TABLE_NAME] DISABLE TRIGGER ALL
ALTER TABLE [TABLE_NAME] NOCHECK CONSTRAINT ALL
'DEV Tool > MSSQL' 카테고리의 다른 글
MSSQL 조회 대상 DELETE (0) | 2010.12.01 |
---|---|
PIVOT 처리 (0) | 2010.09.08 |
DB 정렬방식 오류 처리 방법 (0) | 2010.07.27 |
TempDB가 몬가요? 먹는건가요 우걱우걱.. (0) | 2010.06.30 |
MSSSQL 2008 ALTER TABLE이 안될때?! (0) | 2010.06.15 |