随笔分类 -  数据库

数据库相关笔记
摘要:select top 1000 ROW_NUMBER() OVER (ORDER BY a.name) AS No, a.name AS 表名, isnull(g.[value],'-') AS 说明 from sys.tables a left join sys.extended_properties g on (a.object_id = g.major_id AND g.minor_id... 阅读全文
posted @ 2018-05-24 11:49 ManyBugs 阅读(620) 评论(0) 推荐(0)
摘要:1、SqlServer Update 后面跟 别名,From后的条件就可以跟Select一样来写了 2、Oracle 3、MySql 阅读全文
posted @ 2018-03-07 10:11 ManyBugs 阅读(11796) 评论(1) 推荐(3)