Introduction to Transact SQL (T-SQL) using Microsoft SQL Server

Transact-Structured Query Language (T-SQL) is Microsoft's (& Sybase's) proprietary extension to SQL. T-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.

In this tutorial I provide an introduction to Transact -SQL using Microsoft SQL Server. I also 1) Explain what is Transact SQL (T-SQL). 2) Provide an overview of 20 key T-SQL statements. 3) Demonstration 20 key T-SQL statements 4) Provide sample code used in the tutorial to download @ http://www.analyticsinaction.com/tsql/

T-SQL statements covered include : SELECT Query, UPDATE Query, INSERT, AS, ORDER, CREATE, TRUNCATE, DROP TABLE, DROP DATABASE, INNER JOIN, WHERE, GROUP, SET, BETWEEN and more!

Category:

Education

Tags:

• T-SQL
• SELECT Query
• UPDATE Query
• INSERT
• AS
• ORDER
• CREATE
• TRUNCATE
• DROP TABLE
• DROP DATABASE
• INNER JOIN
• WHERE
• GROUP
• SET

[Darienbeagle]

Thanks!