![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
七千与二十二
这个作者很懒,什么都没留下…
展开
-
泛微常用sql语句
登陆最少统计: select top 5 relatedname,COUNT(*) as c from SysMaintenanceLog where operateitem=60 group by relatedname order by c asc 待办事宜数量前十机构统计: select top 10 (select SUBSTRING(subcompanyname,3,6) from hrmsubcompany where id=subcompanyid1),count(requestid)原创 2024-08-30 14:40:13 · 146 阅读 · 0 评论 -
SQLServer日期格式转换
Select CONVERT(varchar(100), GETDATE(), 24): 10:57:47Select CONVERT(varchar(100), GETDATE(), 108): 10:57:49Select CONVERT(varchar(100), GETDATE(), 12): 060516Select CONVERT(varchar(100), GETDATE(), 23): 2006-05-16select CONVERT(varchar(12) , getdate(), 112原创 2024-08-30 14:46:06 · 315 阅读 · 0 评论