1、说明：创建数据库

CREATE DATABASE database-name

2、说明：删除数据库

drop database dbname

3、说明：备份sql server

--- 创建 备份数据的 device

USE master

EXEC sp_addumpdevice disk , testBack , c:\mssql7backup\MyNwind_1.dat

--- 开始 备份

BACKUP DATABASE pubs TO testBack

4、说明：创建新表

create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)

-1, Descr iption: Create a database CREATE DATABASE database-name 2, Descr iption: delete the database drop database dbname 3, Descr iption: The backup sql server--- create a backup data device USE master EXEC sp_addumpdevice ' disk' , ' testBack' , ' c: \ mssql7backup \ MyNwind_1.dat ' --- start the backup BACKUP DATABASE pubs TO testBack 4, Descr iption: Create a new table create table tabname (col1 type1 [not null] [primary key], col2 type2 [not null ],..)