SQL SERVER 2005 基本查询（连接查询）

最新推荐文章于 2021-09-27 17:28:30 发布

原创最新推荐文章于 2021-09-27 17:28:30 发布 · 895 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #join #null #table #insert

SQL2005学习日志专栏收录该内容

17 篇文章

订阅专栏

本文通过具体的SQL查询案例，展示了如何使用复杂的连接操作、子查询、条件判断等技巧来高效地从数据库中检索所需的数据。文章还介绍了创建表格、添加主键约束及插入数据的方法。

use AdventureWorks GO SELECT c.LastName FROM Person.Contact c; SELECT * FROM HumanResources.Employee e INNER JOIN HumanResources.Employee m ON e.ManagerID = m.EmployeeID; n SELECT ProductID,Name,ProductNumber,ReorderPoint from Production.Product where ProductID in( select ProductID from Production.Product where ProductID in (1,2,3) ) if EXISTS( select ProductID from Production.Product where ProductID in (1,2,3) ) PRINT 'TRUE' ELSE PRINT 'FALSE' SELECT e.EmployeeID,ce.FirstName,ce.LastName FROM HumanResources.Employee e INNER JOIN HumanResources.Employee m ON e.ManagerID = m.EmployeeID INNER JOIN Person.Contact ce ON e.ContactID = ce.ContactID INNER JOIN Person.Contact cm ON m.ContactID = cm.ContactID WHERE cm.FirstName = 'Jo' and cm.LastName = 'Brown'; Select SalesOrderID,SUM(OrderQty) as sum from Sales.SalesOrderDetail where SalesOrderID between 43684 and 43686 group by SalesOrderID having SUM(OrderQty) > 5 create table UserInfor ( UserID int not null, FirstName nvarchar(50), LastName nvarchar(50) ) GO ALTER TABLE UserInfor add primary key (UserID) INSERT INTO UserInfor(UserID,FirstName,LastName) SELECT e.EmployeeID,ce.FirstName,ce.LastName FROM HumanResources.Employee e INNER JOIN HumanResources.Employee m ON e.ManagerID = m.EmployeeID INNER JOIN Person.Contact ce ON e.ContactID = ce.ContactID INNER JOIN Person.Contact cm ON m.ContactID = cm.ContactID WHERE cm.FirstName = 'Jo' and cm.LastName = 'Brown'; declare @MyTable table ( SalesOrderID int, CustomerID int ) INSERT INTO @MyTable(SalesOrderID,CustomerID) select SalesOrderID,CustomerID from AdventureWorks.Sales.SalesOrderHeader where SalesOrderId between 50222 and 50225 select * from @MyTable create table Shippers ( ShipperID int identity not null primary key, ShipperName varchar(30) not null, Address varchar(20) not null, City varchar(25) not null, State char(2) not null, Zip varchar(14) not null, PhoneNo varchar(14) not null UNIQUE ) alter table HumanResources.Employees add CONSTRAINT AK_EmployeeSSN UNIQUE(SSN)