3.1ʹT-SQL䰴Ҫ󴴽qg_testݿ⡣
	USE master
	GO
	CREATE DATABASE qg_test
	ON 
	( NAME = qg_testdat,
  	 FILENAME = 'c:\program files\microsoft sql server\mssql\data\test.mdf',
  	 SIZE = 10,
  	 MAXSIZE = 100,
  	 FILEGROWTH = 10 )
	GO
3.2ʹT-SQL䴴salesݿ⡣
	USE master
	GO
	CREATE DATABASE Sales
	ON 
	( NAME = Sales_dat,
 	  FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',
 	  SIZE = 10,
 	  MAXSIZE = 50,
  	 FILEGROWTH = 5 )
	LOG ON
	( NAME = 'Sales_log',
  	 FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
  	 SIZE = 5MB,
  	 MAXSIZE = 25MB,
  	 FILEGROWTH = 5MB )
	GO
3.3ʹT-SQL䴴Archiveݿ⡣
	USE master
	GO
	CREATE DATABASE Archive 
	ON
	PRIMARY ( NAME = Arch1,
	      FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat1.mdf',
	      SIZE = 100MB,
	      MAXSIZE = 200,
	      FILEGROWTH = 20),
	( NAME = Arch2,
	   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat2.ndf',
	   SIZE = 100MB,
	   MAXSIZE = 200,
	   FILEGROWTH = 20),
	( NAME = Arch3,
	   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat3.ndf',
	   SIZE = 100MB,
	   MAXSIZE = 200,
	   FILEGROWTH = 20)
	LOG ON 
	( NAME = Archlog1,
	   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog1.ldf',
	   SIZE = 100MB,
	   MAXSIZE = 200,
	   FILEGROWTH = 20),
	( NAME = Archlog2,
	   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog2.ldf',
	   SIZE = 100MB,
	   MAXSIZE = 200,
	   FILEGROWTH = 20)
	GO
3.4ʹT-SQL޸qg_testݿ⣬ӴҪļ
	ALTER DATABASE qg_test
	ADD FILE 
	( NAME = qg_testdat2,
	 FILENAME ='c:\program files\microsoft sql server\mssql\data\test2.ndf',
	 SIZE = 10MB,
	 MAXSIZE = 100MB,
	 FILEGROWTH = 10%)
	GO
3.5ʹT-SQL޸qg_testݿ⣬־ļ
	ALTER DATABASE qg_test
	ADD LOG FILE 
	( NAME = qg_testlog2,
	  FILENAME = 'c:\program files\microsoft sql server\mssql\data\qg_testlog2.ldf',
	  SIZE = 5MB,
	  MAXSIZE = 50MB,
	  FILEGROWTH = 5MB),
	GO
3.6ʹT-SQL޸qg_testݿ⣬ɾļ
	ALTER DATABASE qg_test 
	REMOVE FILE qg_testdat2
	GO
3.7ʹT-SQL޸qg_testݿ⣬޸ļĴС
	ALTER DATABASE qg_test 
	MODIFY FILE
	   (NAME = qg_testdat,
	    MAXSIZE = 500M)
	GO
3.8ʹT-SQLɾqg_testݿ⡣
	DROP DATABASE qg_test
3.9ʹT-SQL䴴û͡
	Exec sp_addtype birthday,varchar(11), not null
3.10ʹT-SQLɾûԶ͡
	Exec sp_droptype  birthday
3.11һְ
	CREATE TABLE ְ
	(ְ  int  primay key
	 ְ varchar(20) not null 
	 Ա     char(2)  default С,
	      tinyint  not  null )
3.12меı
	CREATE TABLE mytable
	( col_1  int 
	 col_2  int 
	 col_3  as  col_1+col_2)
3.13бʶеı
	CREATE TABLE 
	(   int  ideneity(1,1) primary key
	  Ʒ   varchar(20) not null 
	        int )
3.14мԼı
	CREATE TABLE ѧ
	( ѧ  int  primay key
	  ѧ varchar(20) not null 
	  Ա     char(2)  default С  check (Ա=С or Ա=Ů),
	       tinyint  not  null check(<100),
	  ϵ绰 varchar(11)  unique)
3.15Լеı
	CREATE TABLE ɼ
	( ѧ  int  references ѧ(ѧ)
	  γ̺ int 
	  ɼ smallint  check(ɼ>0 and ɼ<100) 
          Constraint pk_cj primary key (ѧţγ̺)
 	  constraint fk_cj foreign key(γ̺)references kc(γ̺))
3.16ʹsp_help鿴Ϣ
  	Use  northwind 
	Exec sp_help customers
	Go 
3.17޸ѧгΪ40Ҳֵ
	Alter   table  ѧ  alter  ѧ varchar (40)  not  null
3.18޸ѧУϵַvarchar(50)ֵ
	Alter   table  ѧ  
	add  ϵַ  varchar (50)  null
3.19޸ѧɾϵַ
	Alter   table  ѧ  
	DROP  COLUMN ϵַ  
3.20޸Ŀγ̱µԼγ̱Ϊ
	Alter   table  γ̱  
	add  constraint pk_kc primary key (γ̱)
3.21޸Ŀγ̱γ̱ŵԼɾ
	Alter   table  γ̱  
	Drop  constraint pk_kc 
3.22ΪѧһԼʹáᡱеȡֵֻǡ򡱡Ϻ
	Alter   table  ѧ  
	add  constraint ck_jg  check ( in ,,Ϻ)
	ʹʹһԼЧ
	alter table  ѧ  nocheck  constraint ck_jg
	ΪʹԼЧʹ䣺
	alter table  ѧ  check constraint  ck_jg
3.23ɾѧ
	drop  table  ѧ

