全部手打，只为跟大家一起复习
1、创建数据库：CREATE DATABASE database-name2、删除数据库： drop database dbname
3、备份数据库 ：
(1)创建数据的device：USE master
EXEC sp_addumpdevice "disk","testBack" ,"c:\mssql7backup\MyNwind_1.dat“
（2）开始备份BACKUP DATABASE pubs TO testBack
4、说明：创建新表：create table tabname(col type1[not null][primary key],col2 type2[not null,...])
5、根据已有的表创建新表
A:create table tab_new like tab_old(使用旧表创建新表)
B:create table tab_new as select col,col2...from tab_old definition only
6.删除新表：drop table tabname
7、说明：增加一个列
Alter table tabname addcolumn col type;
8、添加主键 Alter table tablename add primary key(col);
9、创建索引：create[unique] index idxname on tabname (col...)
删除索引：drop index idxname
11、创建视图 create view viewname as select statement
删除视图：drop view viewname
12、几个简单sql语句
选择：select * table from table 1 where 范围
插入：insert into table 1(field1, field2)values(value1 value2)
s删除：delete from table where 范围
更新：updata table1 set field1=value1 where 范围
查找：select * from table1 where field1 like‘%value%'
总数：select count as totalcount from table1
求和：select sum(field1)as sumvalue from table1
最大：select max(field) as maxvalue from table1
平均: select avg(field) as avgvalue from table1

手打如果有错请指出。