![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
db
Brian_Lucky
希望能帮助更多人
展开
-
数据库的字典数据类型导出
数据字典导出。原创 2022-07-29 17:55:02 · 121 阅读 · 0 评论 -
sqlServer将一个表中的字段更新到另一个表中
将表2 中 evaluate 字段更需吧到表1UPDATE [dbo].[表1]SET evaluate = c.evaluateFROM [dbo].[表2] c , [dbo].[表1] i WHERE c.id = i.indexId原创 2020-08-24 15:46:05 · 1870 阅读 · 0 评论 -
sql自定义列名字统计数据
SELECT 0 as status,COUNT(*) as statistic, 'name1' AS copy FROM table WHERE status=0 UNION ALLSELECT 1 as status,COUNT(*) as statistic, 'name2' AS copy FROM table WHERE status=1 UNION ALLSELECT 2 as status,COUNT(*) as statistic, 'name3' A...原创 2020-08-07 15:56:47 · 625 阅读 · 0 评论