1, Description: Create a database CREATE DATABASE database-name 2, Description: delete the database drop database dbname 3, Description: 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, Description: Create a new table create table tabname (col1 type1 [not null] [primary key], col2 type2 [not null ],..)

必学SQL语句大全不学后悔.doc

• We are an exchange download platform that only provides communication channels. The downloaded content comes from the internet. Except for download issues, please Google on your own.
• The downloaded content is provided for members to upload. If it unintentionally infringes on your copyright, please contact us.
• Please use Winrar for decompression tools
• If download fail, Try it againg or Feedback to us.
• If downloaded content did not match the introduction, Feedback to us，Confirm and will be refund.
• Before downloading, you can inquire through the uploaded person information

Nothing．