update mmdoc.mmmslog set pr_mm_dd='0' where (mm_d,mm_id,mm_dor) in (select dd_mm_d,dd_mm_id,dd_mm_dor from mmdoc.mmmslog where date(mm_l_d)>'2006-05-24' and date(dd_mm_d)<='2006-05-24' and dd_mm_dor is not null);
delete from session.mmslog_0;
delete from mmdoc.mmmlog where mm_d='2006-05-24';
delete from mmdoc.mmmm where mm_d='2006-05-24';
delete from mmdoc.mmme where mm_d='2006-05-24';
delete from mmdoc.mmmep where mm_d='2006-05-24';
delete from mmdoc.mmmlst where mm_d='2006-05-24';
delete from mmdoc.mmmlsts where mm_d='2006-05-24';
delete from mmdoc.mmmlstrs where mm_d='2006-05-24';
delete from mmdoc.mmmr where mm_d='2006-05-24';
delete from mmdoc.mmms where mm_d='2006-05-24';
delete from mmdoc.mmmse where mm_d='2006-05-24';
delete from mmdoc.mmmsf where mm_d='2006-05-24';
delete from mmdoc.mmmss where mm_d='2006-05-24';
delete from mmdoc.mmmst where mm_d='2006-05-24';
delete from mmdoc.mmmv where mm_d='2006-05-24';
delete from mmctax.mdosp_0 where mm_d='2006-05-24';
delete from mmctax.mdosp_1 where mm_d='2006-05-24';
delete from mmctax.mdoss_1 where mm_d='2006-05-24';
delete from mmctax.mdosm_0 where mm_d='2006-05-24';
delete from mmdoc.mmmslog where mm_d='2006-05-24';
Declare db_sysdb Cursor fast_forward read_only
For select name from master.dbo.sysdatabases where (NOT name='Parking_new') and RTRIM(CAST(databasepropertyex(name,'recovery') as varchar(255)))='SIMPLE'
Мне лучше маленький домик, ...
[Print]
Ирча