![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
左边的天堂
这个作者很懒,什么都没留下…
展开
-
SQL Server导出存储过程
sqlserver批量导出视图select text from syscomments s1 join sysobjects s2 on s1.id=s2.id where xtype = 'V'sqlserver批量导出存储过程select text from syscomments s1 join sysobjects s2 on s1.id=s2.id where xtype = 'P'sqlserver批量导出函数select text from syscomments s1 jo转载 2021-09-08 10:25:00 · 1525 阅读 · 0 评论 -
sqlserver 常用操作
根据某个字段统计重复数select column1,count(1) total from Table1 WHERE condition1=xxx GROUP BY column1 HAVING count(1)>1计算重复总数select sum(total) total from (select column1,count(1) total from Table1 WHERE condition1=xxx GROUP BY column1 HAVING count(1)>1.原创 2020-06-11 17:58:18 · 228 阅读 · 0 评论