SQL Server 2012数据库T-SQL查询方法及实例解析  

T-SQL Query Method of SQL Server 2012 Database and Example Analysis

作　　者：周旺红 Zhou Wanghong(Jiangsu College of Safety Technology,Xuzhou Jiangsu 221004,China)

机构地区：[1]江苏安全技术职业学院,江苏徐州221004

出　　处：《信息与电脑》2018年第24期144-145,共2页Information & Computer

摘　　要：Transact-SQL是标准SQL程序设计语言的增强版,是程序与SQLServer之间沟通的主要语言。数据库最大的特点是查询的便捷性,几乎所有的数据库操作都是在查询的基础上进行。提高查询速度,给数据的维护带来了方便。基于此,主要以货品订购信息管理数据库为例,介绍了关系型数据库中T-SQL查询语句的用法。主要包括投影、选择、排序和分组统计等查询。Transact-SQL is an enhanced version of standard SQL programming language and the main language for communication between programs and SQL Server.The most important feature of database is the convenience of query.Almost all database operations are carried out on the basis of query.Improve the query speed,and bring convenience to data maintenance.Based on this,this paper mainly introduces the use of T-SQL query statement in relational database,taking the commodity order information management database as an example.It mainly includes queries of projection,selection,ranking and grouping statistics.

关 键 词：SQL SERVER T-SQL 数据库 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]