1、說明：創(chuàng)建數(shù)據(jù)庫CREATEDATABASEdatabase-name2、說明：刪除數(shù)據(jù)庫dropdatabasedbname3、說明：備份sql server--- 創(chuàng)建 備份數(shù)據(jù)的 deviceUSE masterEXECsp_addumpdevice'disk','testBack','c:mssql7backupMyNwind_1.dat'--- 開始 備份BACKUPDATABASEpubsTOtestBack4、說明：創(chuàng)建新表createtabletabname(col1 type1 [notnull] [primarykey],col2 type2 [notnull],..)根據(jù)已有的表創(chuàng)建新表：A：createtabletab_newliketab_old (使用舊表創(chuàng)建新表)B：createtabletab_newasselectcol1,col2…<code class="sql keyword" style="white-space:pre-wrap; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.8em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; min-height:inherit!important; color:rgb(0,0,255)!important; background:none!import