Declare Cur Cursor For
Select name From T_NAME
declare @name varchar(20),@SQL Varchar(2000)
Open Cur
Fetch Cur Into @name
While @@FETCH_STATUS=0
BEGIN
Set @sql='Delete From '+@name
Exec(@sql)
Fetch Cur Into @name
End
Close Cur
Deallocate cur
Select name From T_NAME
declare @name varchar(20),@SQL Varchar(2000)
Open Cur
Fetch Cur Into @name
While @@FETCH_STATUS=0
BEGIN
Set @sql='Delete From '+@name
Exec(@sql)
Fetch Cur Into @name
End
Close Cur
Deallocate cur
Declare Cur Cursor For
Select name From T_NAME
declare @name varchar(20),@SQL Varchar(2000)
Open Cur
Fetch Cur Into @name
While @@FETCH_STATUS=0
BEGIN
Set @sql=Truncate Table '+@name
Exec(@sql)
Fetch Cur Into @name
End
Close Cur
Deallocate cur