alter table tblplaylog alter column chip nvarchar(50) update TelsaCo.dbo.OfflineRecordServers set TelsaCo.dbo.OfflineRecordServers.IsActive='2' delete from OfflineCallInfo where OfflineCallInfo.RecordServerID in(select ServerID from OfflineRecordServers where OfflineRecordServers.ServerIP is null or OfflineRecordServers.ServerIP='')