数据库查询与操作实战：SQL语句与联合查询技巧-CSDN博客

本文档详细记录了工作中常用的SQL查询语句，包括基本的全表查询、字段选择、条件查询，以及针对两个表的联接操作。还展示了日期函数和不同类型的数据库连接方式，适合数据库开发者参考。

工作中用到的数据库语句记录

-- SELECT * FROM [Sample].[dbo].[samrecord]
--select * from dbo.samrecord; -- 查询所有记录
--select id,carnumber,mineral from dbo.samrecord; --指定字段
-- 条件查询 where 指定车号，日期
--select * from dbo.samrecord where carnumber = '晋C38028';
--select * from dbo.samrecord where recordtime = '2016-08-01';
--select * from dbo.samrecord where YEAR(recordtime) = '2016' and MONTH(recordtime) = '08' and DAY(recordtime) = '01';
--select * from dbo.samrecord where YEAR(recordtime) = '2016';
-- 两表联合查询 samrecord Truck

--select dbo.samrecord.carnumber,dbo.samrecord.mineral,dbo.samrecord.recordtime,dbo.Truck.TLenth,dbo.Truck.TWidth,dbo.Truck.THight from dbo.samrecord,dbo.Truck where dbo.samrecord.carnumber = dbo.Truck.Chehao;
--select dbo.samrecord.carnumber,dbo.samrecord.mineral,dbo.samrecord.recordtime,dbo.Truck.TLenth,dbo.Truck.TWidth,dbo.Truck.THight from dbo.samrecord inner join dbo.Truck on dbo.samrecord.carnumber = dbo.Truck.Chehao;
--select sd.carnumber,sd.mineral,sd.recordtime,tk.TLenth,tk.TWidth,tk.THight from dbo.samrecord as sd,dbo.Truck as tk where sd.carnumber = tk.Chehao;
select sd.carnumber,sd.mineral,sd.recordtime,tk.TLenth from dbo.samrecord as sd inner join dbo.Truck as tk on sd.carnumber = tk.Chehao;

--select sd.carnumber,sd.mineral,sd.recordtime,cy.榜单号 from dbo.samrecord as sd inner join dbo.CYJ as cy on sd.carnumber = cy.车牌号;
--select sd.carnumber,sd.mineral,sd.recordtime,cy.榜单号 from dbo.samrecord as sd left outer join dbo.CYJ as cy on sd.carnumber = cy.车牌号;
--select sd.carnumber,sd.mineral,sd.recordtime,cy.榜单号 from dbo.samrecord as sd right outer join dbo.CYJ as cy on sd.carnumber = cy.车牌号;
--select sd.carnumber,sd.mineral,sd.recordtime,cy.榜单号 from dbo.samrecord as sd full outer join dbo.CYJ as cy on sd.carnumber = cy.车牌号;
--select sd.carnumber,sd.mineral,sd.recordtime,cy.榜单号 from dbo.samrecord as sd cross join dbo.CYJ as cy;

select GETDATE(); -- 当前系统时间;
select DATEDIFF(DAY,'2021-08-01','2021-08-11');
select CONVERT(varchar(10),GETDATE(),120);--当前日期
select CONVERT(varchar(8),GETDATE(),114); --当前时间