删除多表数据

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[DelDataTable]
AS
BEGIN
 DECLARE @tablename VARCHAR(80)
 DECLARE @cSql  VARCHAR(8000)
 SET @cSql = ''

 DECLARE cur_authors cursor
 for
 SELECT  [name] from sysobjects where [name] like 'T%' and type ='U'
 open cur_authors
 fetch next from cur_authors into @tablename
 while(@@fetch_status=0)
 begin
  SET @cSql = + 'delete from'+ ' ' + @tablename
  EXEC(@cSql)
  set @cSql = ''
  fetch next from cur_authors into @tablename
    end
 close cur_authors
 deallocate cur_authors
END