删除大量用户表内的数据(表名都具有相似的特点,如:cbmn_tablename1,cbmn_tablename2)
DECLARE @tablename varchar(100)
DECLARE @deletesql nvarchar(100)
DECLARE table_name CURSOR FOR
SELECT name FROM sysobjects WHERE xtype='u' and name like'ss%'
OPEN table_name
FETCH NEXT FROM table_name into @tablename
SELECT name FROM sysobjects where xtype='u' and name=@tablename
Set @deletesql='delete from '+@tablename
EXEC sp_executesql @deletesql
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM table_name into @tablename
Set @deletesql='DELETE FROM '+@tablename
EXEC sp_executesql @deletesql
END
CLOSE table_name
DEALLOCATE table_name