随笔分类 -  sql

left join 、right join 、inner join 和 full join 的区别
摘要：1、先创建数据库 use master go if exists( select * from sysdatabases where name='DataTest') begin drop database DataTest end else begin create database DataTe 阅读全文
posted @ 2022-01-13 21:55 一抹上扬的微笑 阅读(263) 评论(0) 推荐(0)
sql update left
摘要：update Accounts set functionpostid ='2AE52014-C9EB-4ECE-A514-156F30BA67CC' from Accounts a left join CommonFunctionPost b on a.functionpostid=b.c_id w 阅读全文
posted @ 2022-01-13 16:24 一抹上扬的微笑 阅读(141) 评论(0) 推荐(0)