Форум компании Смарт-Софт

<br><br>CREATE PROCEDURE [dbo].[ClearLog] @Date DateTime, @ServerID int<br>AS<br>BEGIN<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM AdminGroupLog WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM AdminLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM AVLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM ExtCounterLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM NetStatLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM ProxyLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM SMTPFltLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM SMTPSendLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM SMTPTraceLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM TariffLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM UserBillLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM UserCounterLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE FROM UserLog<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ([Time]&lt;@Date) and (ServerID=@ServerID)<br>END<br><br>