一段用于清空数据库中所有的用户表的SQL语句[原创]

[已修改]
感谢五楼的指正

--清空数据库中所有的用户表
--可以为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 --删除以释放游标