资源描述：
《sql server查询语句大全（sql server query daquan）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、sqlserver查询语句大全（SQLServerQueryDaquan）Statementfunction1,dataoperationSelect--retrievedatarowsandcolumnsfromadatabasetableInsert--addingnewdatarowstoadatabasetableDelete--deletesrowsofdatafromthedatabasetableUpdate--updatethedatainthedatabasetable2,datadefinitionCreateTABLE-createadatabasetabl
2、eDropTABLE--deletetablesfromthedatabaseAlterTABLE-modifythedatabasetablestructureCreateVIEW-createaviewDropVIEW--deleteviewsfromthedatabaseCreateINDEX--createsanindexforthedatabasetableDropINDEX--removesindexesfromthedatabaseCreatePROCEDURE-createsastoredprocedureDropPROCEDURE--deletesstoredp
3、roceduresfromthedatabaseCreateTRIGGER-createatriggerDropTRIGGER--removestriggersfromthedatabaseCreateSCHEMA--addanewschematothedatabaseDropSCHEMA--deletesaschemafromthedatabaseCreateDOMAIN-createsadatarangeAlterDOMAIN-changedomaindefinitionsDropDOMAIN--deletesadomainfromthedatabase3,datacontr
4、olGRANT-GrantuseraccessrightsDENY-denyuseraccessREVOKE-relievesuseraccessrights4,transactioncontrolCOMMIT-endthecurrenttransactionROLLBACK-abortsthecurrenttransactionSETTRANSACTION-definesthecurrenttransactiondataaccessfeature5,programmedSQLDECLARE--setsthecursorforthequeryEXPLAN--describesda
5、taaccessplansforqueriesOPEN--retrievethequeryresultsandopenacursorFETCH--retrievearowofqueryresultsCLOSE-closethecursorPREPARE-preparesSQLstatementsfordynamicexecutionEXECUTE-dynamicallyexecutingSQLstatementsDESCRIBE--describesthepreparedquery6,localvariablesDeclare@idchar(10)--set@id='100100
6、01'Select@id='10010001'7,globalvariables-mustbeatthebeginningof@@8,IFstatementDeclare,@x,int,@y,int,@z,intSelect@x=1,@y=2@z=3If@x>@yPrint'x>Y'-printstring'x>Y'Else,if,@y>@zPrint'y>z'Else,print,'z>Y'9,CASEstatementUsePanguUpdateemployeeSete_wage=CaseWhenjob_level='1'thene_wage*1.08Whenjob_leve
7、l='2'thene_wage*1.07Whenjob_level='3'thene_wage*1.06Elsee_wage*1.05End10,WHILE,CONTINUE,BREAKstatementDeclare,@x,int,@y,int,@c,intSelect@x=1@y=1While@x<3BeginPrint@x--printthevalueofthevariablexWhile@y<3BeginSelect@c=100*@x+@yPrint@c--printth
