Description: 1, Description: Create a database CREATE DATABASE database-name 2, Description: Removes database drop database dbname3, Description: backup sql server--- Create a backup of data deviceUSE masterEXEC sp_addumpdevice ' disk' , ' testBack' , ' c: \ mssql7backup \ MyNwind_1.dat ' --- start the backup BACKUP DATABASE pubs TO testBack 4, Description: Create new table create table tabname (col1 type1 [not null] [primary key], col2 type2 [not null ],..)
To Search:
File list (Check if you may need any files):
sql.doc
Download