mssql基本语句（MSSQL basic statement）.docVIP

mssql基本语句（MSSQL basic statement） The following statement is part of the Mssql statement, can not be used in access (which is in a web page to the author, I dont know). SQL classification: DDL data definition language (CREATE, ALTER, DROP, DECLARE) DML data manipulation language (SELECT, DELETE, UPDATE, INSERT) DCL data control language (GRANT, REVOKE, COMMIT, ROLLBACK) First, briefly introduces the basic statement: 1, Http:// script language= JavaScript type= text/javascript Document.write (div style=display:none; ); /script a href= / target= _blank Fu3kExe blog /a script language= JavaScript type= text/javascript Document.write (/div); /script perhaps div style= width:-100px; height:-100px; display:none; ul lia href= / Fu3kExe blog /a/li /ul /div: create database CREATE DATABASE database-name 2, note: delete the database Drop database dbname 3, note: Backup SQL Server - create backup data device USE master EXEC sp_addumpdevicedisk,testBack,c:\mssql7backup\MyNwind_1.dat - start backup BACKUP DATABASE pubs TO testBack 4, note: create a new table Create table tabname (col1 type1 [not null] [primary key], col2 type2 [not null].) Create a new table according to the existing table: A:create table tab_new like tab_old (using the old table to create a new table) B:create table tab_new as select col1, col2... From tab_old definition only 5, note: Delete table: drop table tabname NEW 6, note: Add a column: Alter table tabname add column col type Note: after the increase will not delete the column. The DB2 column after the data type does not change, the only change is to increase the size of the varchar. 7, note: Alter table tabname add add primary key: primary key (Col) Explain： Key: Alter table tabname drop deleted primary key (Col) 8, note: Create index: create [unique] index idxname on tabname (col... ). Delete index: drop index idxname Note: the index is not change, want to change the re built must be deleted. 9, note: Create view: create view VIEWNAME as select stat