[已修改]
感谢五楼的指正
--清空数据库中所有的用户表
--可以为crdate字段指定表的创建日期
DECLARE crsr CURSOR
FOR
SELECT[name] FROM DBO.SYSOBJECTS
WHERE OBJECTPROPERTY(ID, N'IsTable') = 1 AND type = 'U' AND [name] <> 'dtproperties' --AND crdate...
OPEN crsr
DECLARE @tblName sysname
FETCH NEXT FROM crsr INTO @tblName
WHILE @@fetch_status = 0
BEGIN
EXEC('TRUNCATE TABLE' + @tblName)
FETCH NEXT FROM crsr INTO @tblName
END
CLOSE crsr
DEALLOCATE crsr --删除以释放游标