T-SQL语法大全(T-sql)

《T-SQL语法大全(T-sql)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、SQLServer编程入门作者：徐佳T—SQL目录一、T—SQL的组成................................................................................................................................................11、DML(数据操作语言DATAMANIPULATIONLANGUAGE)....................................................................

2、............12、DCL(数据控制语言DATACONTROLLANGUAGE)..........................................................................................13、DDL(数据定义语言DATADEFINITIONLANGUAGE).......................................................................................14、变量说明、流程控制、功能函数..........

3、.......................................................................................................1二、库.......................................................................................................................................................................11、建立库.....

4、........................................................................................................................................................12、删除库...............................................................................................................................

5、..............................2三、表.......................................................................................................................................................................21、建表...............................................................................

6、..................................................................................22、删表.................................................................................................................................................................3四、约束................................

7、...................................................................................................................................31、主键(PRIMARYKEY).........................................................................................................................................

8、32、唯一