sql 随笔

1 --日期运算 2 (DATEDIFF ( DAY , tblW.CreatTime , GETDATE() ) <=tblW.Effective 1 --日期格式化
2 CONVERT(VARCHAR(20),A.addTime,120) as 添加时间
3 --报错日志表
4 select * from  LogDB.DBO.SysProErrLogTbl order by id desc
5 --隐藏字符
6 stuff(A.UUID,8,20,'**********') AS 设备码

1 --日期运算 (DATEDIFF ( DAY , tblW.CreatTime , GETDATE() ) <=tblW.Effective