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
