SQL语句对一些表与字段的基本操作及提高、技巧（国外英文资料）.docVIP

SQL语句对一些表与字段的基本操作及提高、技巧（国外英文资料） A basis, Note: create a database The CREATE DATABASE DATABASE - name Note: delete the database The drop database dbname 3, note: The backup of SQL server - create the device that backs up the data USE the master EXEC sp_addumpdevice disk, testBack, c: mssql7backupmynwind_1.dat - - start backing up BACKUP the DATABASE pubs TO testBack Explanation: create a new table Create table tabname (col1 type1 [not null], col2 type2 [not null],..) Create a new table based on the existing table: A: create table tab_new like tab_old (using the old table to create A new table)