SQL语言基础练习---数据库server 2008（三）

--concatenate链接
select region_name + " "+store_name FROM Geography
WHERE store_name = 'Boston';




--SUBSTRING
select substring(store_name,3)
FROM Geography
where store_name='LOS'


--TRIM : 用来除掉字符串的字头或字尾
select LTRIM(' Sample ')
--或者
select RTRIM(' Sample ')






--创建表
Create TABLE customer(
First_Name Char(5),
Last_Name char(5),
Address char(50),
City char(50),
country char(25),
Birth_Date date);


--Constraint




--NOT NULL
CREATE TABLE Customer(
SID integer NOT NULL,
Last_Name varchar(39) NOT NULL,
Fist_Name varchar(30));




--UNIQUE
CREATE TABLE Customer(
SID integer Unique,
Last_Name varchar(30),
First_Name varchar(30));






--CHECK
CREATE TABLE Customer(
SID interge CHECK(SID>0),
Last_Name varchar(30),
First_Name varchar(30));


--CREATE VIEW
create view "view_NAME" AS "SQL语句"




create VIEW V_Customer
AS SELECT First_Name,Last_Name,Country
FROM Customer




VIEW V_Customer(
First_Name char(50),
Last_name char(50),
Country char(25));
--as复制后面的全部数据
create view v_REGION_SALES
AS  select........
................








--INDEX 
TABLE customer(
First_Name Char(5),
Last_Name char(5),
Address char(50),
City char(50),
country char(25),
Birth_Date date);
create INDEX IDX_Customer_LAST_NAME
on customer(Last_name)