AM群消息歷史記錄服務器端清理

Declare @strSQL as nvarchar(1024)

Declare @strTable as nchar(19)

Declare @nOrder as int

Declare @strTabOrder as nvarchar(3)

Set @nOrder = 1

While @nOrder < 1000

Begin

Set @strTabOrder = REPLACE( str( @nOrder, 3 ), N’ ‘, N’0’ )

Set @strTable= N’OI_CROWD_C_MSG_T’ + @strTabOrder

— 判斷數據表是否存在，不存在就結束

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[‘ + @strTable + ‘]’) AND OBJECTPROPERTY(id, N’IsUserTable’) = 1)

RETURN

— 執行刪除記錄，刪除指定日期之前的記錄

Set @strSQL = N’Delete ‘ + @strTable + N’ Where T_C5 < ”2017-10-07”’

EXECUTE sp_executesql @strSQL

Set @nOrder = @nOrder + 1

End