db
老艺术家 小雨
希望能帮助更多人
展开
-
数据库的字典数据类型导出
数据字典导出。原创 2022-07-29 17:55:02 · 153 阅读 · 0 评论 -
sqlServer将一个表中的字段更新到另一个表中
将表2 中 evaluate 字段更需吧到表1 UPDATE [dbo].[表1] SET evaluate = c.evaluate FROM [dbo].[表2] c , [dbo].[表1] i WHERE c.id = i.indexId原创 2020-08-24 15:46:05 · 1910 阅读 · 0 评论 -
sql自定义列名字统计数据
SELECT 0 as status,COUNT(*) as statistic, 'name1' AS copy FROM table WHERE status=0 UNION ALL SELECT 1 as status,COUNT(*) as statistic, 'name2' AS copy FROM table WHERE status=1 UNION ALL SELECT 2 as status,COUNT(*) as statistic, 'name3' A...原创 2020-08-07 15:56:47 · 659 阅读 · 0 评论