chapter15examples.sqlce

< SQL Server2005程序设计>

--Connect to the new SQL Server Mobile database

--Example 1. Create a table and add a PK constraint
Create Table Customers (Customer_ID INTEGER IDENTITY(1,1) 
CONSTRAINT pkCustId PRIMARY KEY, CustomerName nvarchar(50),Region_ID int)

--Example 2. Create the region table and insert data
--Listing 15-1
Create Table Region (Region_ID INTEGER IDENTITY(1,1)
CONSTRAINT pkRegId PRIMARY KEY, RegionName nvarchar(50) NOT NULL)
Go
Insert Into Region (RegionName) values( 'USA')
Go
Insert Into Region (RegionName) values('Europe')
Go
Insert Into Region (RegionName) values('Asia')
Go
Insert Into Region (RegionName) values('South American')
Go
Insert Into Region (RegionName) values('Africa')
Go
Insert Into Customers (CustomerName, Region_ID) 
	values ('Stephen', 1)
Go
Insert Into Customers (CustomerName, Region_ID) 
	values ('Goksin', 2)
Go
Insert Into Customers (CustomerName, Region_ID) 
	values ('Malek', 3)
Go
Insert Into Customers (CustomerName, Region_ID) 
	values ('Kimberly', 4)
Go
Insert Into Customers (CustomerName, Region_ID) 
	values ('Clemens', 5)
Go
Insert Into Customers (CustomerName, Region_ID) 
	values ('Richard', 1)
Go

--Example 3: Simple Select
Select * From Customers

--Use for Display Execution Plan Query
Select RegionName, Count(*) as CountofRegions
From Customers inner join Region
	on Customers.Region_ID=Region.Region_ID
Group By RegionName, Customers.Region_ID