![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLServer
MRZZXzzx
这个作者很懒,什么都没留下…
展开
-
获取SQLServer中表结构字段
select syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length from syscolumns,systypes where syscolumns.xusertype=systypes.xusertype and syscolumns.id=OBJECT_ID('表名')原创 2017-08-27 22:13:16 · 318 阅读 · 0 评论 -
获取本年的黄牌和红牌之和
select d.did,isnull(sum(a.yellowwarning),0) yellows, isnull(sum(a.redwarning)*(-1),0) reds from department d left join SYS_USER u on d.did=u.depid left join (select * from approveInfo where datedif原创 2017-09-08 01:52:06 · 247 阅读 · 0 评论