清除数据库里面的所有表数据(转)

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo-- =============================================-- Author:<Author,,Name>-- Create date: <Create Date,,>-- Description:<Description,,>-- =============================================ALTER PROCEDURE [dbo].[deldata] ASBEGINDECLARE tables_cursor CURSOR     FOR     SELECT name FROM sysobjects WHERE type = 'U' ---选择用户表名  OPEN tables_cursor --打开游标连接   DECLARE @tablename sysname   -- 定义变量  FETCH NEXT FROM tables_cursor INTO @tablename   --结果集中一行一行读取表名  WHILE (@@FETCH_STATUS <> -1) --//判断游标状态   BEGIN      EXEC ('DELETE from ' + @tablename)   ---清空表中的数据     FETCH NEXT FROM tables_cursor INTO @tablename --下一行数据  END   DEALLOCATE tables_cursor --//关闭游标END