T-SQL Tutorials - TSQLTutorials.com

Introduction and Definitions



This site will primarily focus on T-SQL used with Microsoft SQL Server. Most examples are for Microsoft SQL Server 2005, but most will work for earlier and later editions. The site will be updated as new editions of SQL Server are released. The Pages that aren't not linked in the navigation bar, have not yet be completed. Please help us complete the pages by giving a small donation (Button on left menu bar).

For those just starting with SQL Server, some definitions are provided below:

SQL stands for Structured Query Language. It is most often pronounced "sequel" or sometimes pronounced by spelling out the letters "S-Q-L". SQL is a query language that is used to interact and perform tasks with relation databses. This language was originally developed by IBM in the 1970s.

T-SQL (Transact SQL) is a proprietary SQL extension used by Microsoft SQL Server and Sybase SQL Server. T-SQL adds extensions for procedural programming.

A Relational Database is a method of structuring data in the form of records so that relationships between seperate entities and attributes can be used for data access. A database stores the data in two-dimensional tables (relations) that can be joined by keys in one or more columns (attributes)

A RDBMS (Relational Database Management System) is the software system that manages a relational database. Examples of a RDBMSs are Microsoft SQL Server, Oracle, MySQL, Microsoft Access, DB2, Sybase SQL Server.


Microsoft SQL Server 2014 Standard Edition Server w/20 CAL’s

Price: $641.99
Buy It Now
Microsoft SQL 2008 R2 Server Standard 10 CAL 32/64-Bit NEW SEALED

Current Price: $295
Current Bids: 0
Microsoft SQL Server 2012 Standard Server +10CAL License Key Factory Sealed Pack

Price: $895
Buy It Now
Microsoft SQL Server 2008 R2 Standard 10CAL Server License key FactorySealedPack

Price: $589
Buy It Now
MSFT SQL Server 2016 Standard Edition x64 64bit | Full Editon | Original | 10CAL

Price: $699.99
Buy It Now
Microsoft SQL Server 2008R2 Standard 25CAL +Server License Key FactorySealedPack

Price: $699
Buy It Now







Copyright 2017 - TSQLTutorials.com