資源描述:
《T-SQL語法大全(T-sql)》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、SQLServer編程入門作者:徐佳T—SQL目錄一、T—SQL的組成................................................................................................................................................11、DML(數(shù)據(jù)操作語言DATAMANIPULATIONLANGUAGE)....................................................................
2、............12、DCL(數(shù)據(jù)控制語言DATACONTROLLANGUAGE)..........................................................................................13、DDL(數(shù)據(jù)定義語言DATADEFINITIONLANGUAGE).......................................................................................14、變量說明、流程控制、功能函數(shù)..........
3、.......................................................................................................1二、庫.......................................................................................................................................................................11、建立庫.....
4、........................................................................................................................................................12、刪除庫...............................................................................................................................
5、..............................2三、表.......................................................................................................................................................................21、建表...............................................................................
6、..................................................................................22、刪表.................................................................................................................................................................3四、約束................................
7、...................................................................................................................................31、主鍵(PRIMARYKEY).........................................................................................................................................
8、32、唯一