SQL_Server优化

*******************************************

SQL关键字详解
升序排序 ASC
-------------------------------------------------------

创建数据库
use master
go
create database ShuJuKu
go
---------------------------------------

创建表
use ShuJuKu
go
create table Biao(ID int not null)
go
------------------------------------------------------

给表增加字段
use ShuJuKu
go
alter table Biao add Lie_1 varchar, Lie_2 char, Lie_3 int;
go
------------------------------------------------------------

创建非聚集索引
use ShuJuKu
go
create index SuoYin on Biao(ID, Lie_1)
go
----------------------------------------------------

删除索引
use ShuJuKu
go
if exists(select name from sys.indexes where name = N'SuoYin') drop index SuoYin on Biao
go
----------------------------------------------------------------------------