T-SQL Tutorial
T-SQL (Transact-SQL) is an extension of SQL language. This tutorial covers the fundamental concepts of T-SQL such as its various functions, procedures, indexes, and transactions related to the topic. …
T-SQL - Quick Guide - Online Tutorials Library
T-SQL - Overview In 1970's the product called 'SEQUEL', structured English query language, developed by IBM and later SEQUEL was renamed to 'SQL' which stands for Structured Query Language.
T-SQL - Overview - Online Tutorials Library
Different RDBMS product vendors have developed their own database language by extending SQL for their own RDBMS products. T-SQL stands for Transact Structure Query Language which is a …
T-SQL - WHERE Clause - Online Tutorials Library
The MS SQL Server WHERE clause is used to specify a condition while fetching the data from single table or joining with multiple tables.
T-SQL - Data Types - Online Tutorials Library
SQL Server data type is an attribute that specifies types of data of any object. Each column, variable and expression has related data type in SQL Server. These data types can be used while creating …
T-SQL - Functions - Online Tutorials Library
MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions ?
T-SQL - Transactions - Online Tutorials Library
A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by …
T-SQL - GROUP BY Clause - Online Tutorials Library
The SQL Server GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups.
T-SQL - Create Tables - Online Tutorials Library
Creating a basic table involves naming the table and defining its columns and each column's data type. The SQL Server CREATE TABLE statement is used to create a new table. Syntax Following is the …
T-SQL - Stored Procedures - Online Tutorials Library
The MS SQL Server Stored procedure is used to save time to write code again and again by storing the same in database and also get the required output by passing parameters.