平台实时弹框消息提醒SQL



SQL写法如下：

Insert into SC_LZHH_PlatformBaseDB.dbo.T_PopupMessage(title,sendtime,sender,receiver,state,sendtitle)

select '系统将在5分钟后进行一次升级,请大家保存好手头工作,于20分钟后重新登录系统,谢谢!',GETDATE(),'4735',z.EmpID,0,CONVERT(varchar(30),getdate(),20)

fromSC_LZHH_PlatformBaseDB.dbo.T_EntryUserLog x

left joinSC_LZHH_PlatformBaseDB.dbo.T_User z on x.UserName=z.LoginID

left joinSC_LZHH_PlatformBaseDB.dbo.T_Employee y on z.EmpID=y.EmpID

where x.logtime>='2015-02-05'