16 Haziran 2016 Perşembe

Sql Server Veritabanındaki Tüm Tablolardaki Tüm kayıtları Temizleme (Silme)

DECLARE @Nombre NVARCHAR(MAX);
DECLARE curso CURSOR FAST_FORWARD
FOR
Select TableName AS Nombre from App.DeleteTables ORDER BY TableOrder
OPEN curso
FETCH NEXT FROM curso INTO @Nombre

WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
DECLARE @statement NVARCHAR(200);
SET @statement = 'DELETE FROM ' + @Nombre;
print @statement
execute sp_executesql @statement;
END
FETCH NEXT FROM curso INTO @Nombre
END
CLOSE curso
DEALLOCATE curso

0 yorum:

Yorum Gönder