摘要:
实例数据库名称:Cynosure--删除数据库中所有数据USE CynosureDECLARE tablecur CURSORFORSELECT [name] FROM sysobjects WHERE TYPE='U'DECLARE @tabname VARCHAR(100)OPEN tablecurFETCH NEXT FROM tablecur INTO @tabnameWHILE(@@FETCH_STATUS = 0)BEGINEXEC('delete from ' + @tabname)PRINT(@tabname + '表数据已被删除' 阅读全文