T-SQL编程入门经典

《T-SQL编程入门经典》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

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

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

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

4、........................................................................12、删除库............................................................................................................................................2三、表.................................................

5、.....................................................................................................21、建表................................................................................................................................................22、删表................

6、................................................................................................................................3四、约束..........................................................................................................................................

7、........31、主键(PRIMARYKEY)........................................................................................................................32、唯一性(UINQUE)................................................................................................................

8、.............43、默认填写(DEFAULT('……')FOR).................................................................