|
declare @link_table nvarchar(255)
declare @local_table nvarchar(255)
declare @Statement nvarchar(300)
declare table_list cursor for select name from sys.tables
open table_list
fetch next from table_list into @link_table
while @@FETCH_STATUS = 0
begin
BEGIN try
SET @Statement = N'delete from [AX2009_SP1_Dev].[dbo].[' + @link_table + '] where [DATAAREAID] in (''DMOV'',''ETC'')'
print @Statement
execute sp_executesql @Statement
end try
begin catch
print @link_table + ' has no DATAAREAID'
end catch
fetch next from table_list into @link_table
end
close table_list
deallocate table_list
| 
Tools 
