--
清空数据库中所有用户自建表中的数据
DECLARE @myTableName varchar ( 40 )
DECLARE delData_cursor CURSOR FOR
select [ name ] from sysobjects where xtype = ' u '
OPEN delData_cursor
FETCH NEXT FROM delData_cursor
INTO @myTableName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ' TableName: ' + @myTableName
-- 注意这里,不能直接写
-- delete from @myTableName
-- 要以如下格式写
EXEC ( ' delete from [ ' + @myTableName + ' ] ' )
FETCH NEXT FROM delData_cursor INTO @myTableName
END
CLOSE delData_cursor
DEALLOCATE delData_cursor
GO
DECLARE @myTableName varchar ( 40 )
DECLARE delData_cursor CURSOR FOR
select [ name ] from sysobjects where xtype = ' u '
OPEN delData_cursor
FETCH NEXT FROM delData_cursor
INTO @myTableName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ' TableName: ' + @myTableName
-- 注意这里,不能直接写
-- delete from @myTableName
-- 要以如下格式写
EXEC ( ' delete from [ ' + @myTableName + ' ] ' )
FETCH NEXT FROM delData_cursor INTO @myTableName
END
CLOSE delData_cursor
DEALLOCATE delData_cursor
GO