爱在屋檐下

摘要： USE [数据库名]DECLARE @Table VARCHAR(100)DECLARE myCursor CURSOR FOR SELECT t.name FROM sys.tables tOPEN myCursorFETCH NEXT FROM myCursor INTO @TableWHILE @@FETCH_STATUS=0BEGINEXEC('TRUNCATE TABLE '+@Table+'')FETCH NEXT FROM myCursor INTO @TableENDCLOSE myCursorDEALLOCATE myCursor适用情况：数据 阅读全文