摘要: (1)Left join 更新update a set a.name=b.name from a left join b on a.id=b.stuid(2)ROW_NUMBERselect ROW_NUMBER() over(partition by name order by score) as 阅读全文
posted @ 2018-06-13 14:50 zhaogaojian 阅读(311) 评论(0) 推荐(0) 编辑
摘要: SQL导入Excel时报以上错误。删除系统更新KB4041681和 KB4041678,重启系统即可 阅读全文
posted @ 2018-06-13 10:22 zhaogaojian 阅读(817) 评论(0) 推荐(0) 编辑