SQL Server数据应用在不同的数据库中(2)

CREATE DATABASE [Test_Cross_1] ON PRIMARY 
( NAME = N'Test_Cross_1', FILENAME = N'
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATATest_Cross_1.mdf', 
SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) 
LOG ON ( NAME = N'Test_Cross_1_log', 
FILENAME = N'C:aProgram FilesMicrosoft 
SQL ServerMSSQL.1MSSQLDATATest_Cross_1_log.ldf', 
SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)GO

USE [Test_Cross_1]

GO

CREATE TABLE [dbo].[Orders_1]
( [OrderNumber] [int] NOT NULL,
 [OrderDate] [datetime] NOT NULL, 
CONSTRAINT [PK_Orders_1] PRIMARY KEY CLUSTERED 
( [OrderNumber] ASC)WITH (PAD_INDEX = OFF, 
STATISTICS_NORECOMPUTE = OFF, 
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]

CREATE DATABASE [Test_Cross_2] ON PRIMARY 
( NAME = N'Test_Cross_2', 
FILENAME = N'C:Program FilesMicrosoft 
SQL ServerMSSQL.1MSSQLDATATest_Cross_2.mdf', 
SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) 
LOG ON ( NAME = N'Test_Cross_2_log', 
FILENAME = N'C:Program FilesMicrosoft 
SQL ServerMSSQL.1MSSQLDATATest_Cross_2_log.ldf', 
SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)GO

CREATE TABLE [dbo].[Orders_2]
( [OrderNo] [int] NOT NULL, [OrderDate] [datetime] 
NOT NULL CONSTRAINT [DF_Orders_2_OrderDate] 
DEFAULT (getdate()), CONSTRAINT [PK_Orders_2] 
PRIMARY KEY CLUSTERED ( [OrderNo] ASC)WITH 
(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

SELECT * FROM Test_Cross_1.dbo.Orders_1INNER 
JOIN Test_Cross_2.dbo.Orders_2

ON Test_Cross_1.dbo.Orders_1.OrderNumber

SELECT * FROM Test_Cross_1.dbo.Orders_1LEFT OUTER 
JOIN Test_Cross_2.dbo.Orders_2

ON Test_Cross_1.dbo.Orders_1.OrderNumber

SELECT * FROM Test_Cross_2.dbo.Orders_2LEFT OUTER 
JOIN Test_Cross_1.dbo.Orders_1

ON Test_Cross_2.dbo.Orders_2.OrderNo