/**********************************************************************
存储过程: P_DelAllUserTableData
功能: 利用游标删除所有水质用户表数据
参数: 无
返回: 无
调用方法: Exec P_DelAllUserTableData
作者:
联系方式:
版权所有:
最后更改日期: 2005-8-16
**********************************************************************/
CREATE PROC P_DelAllUserTableData
as
Begin
declare @name varchar(20)
Declare Cur Cursor For
select Name from sysobjects where xtype='u' and status>=0 and Name like '%WQ_%'
declare @SQL Varchar(20)
Open Cur
Fetch Cur Into @name
While @@FETCH_STATUS=0
BEGIN
Set @sql='DELETE '+@name+''
Exec(@sql)
Fetch Cur Into @name
End
Close Cur
Deallocate cur
End
GO