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. Each topic is explained using examples for easy understanding.
T-SQL - Quick Guide - Online Tutorials Library
T-SQL stands for Transact Structure Query Language which is a Microsoft product and is an extension of SQL Language. Example. MS SQL Server - SQL\T-SQL. ORACLE - SQL\PL-SQL. T-SQL - Data Types. 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.
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.. The GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause. Syntax. Following is the basic syntax of GROUP BY clause.
T-SQL - Overview - 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. Home Library
T-SQL - Create Tables - Online Tutorials Library
T-SQL - Create Tables. Previous Next 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 basic syntax of …
T-SQL - Stored Procedures - Online Tutorials Library
T-SQL - Stored Procedures - 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.
T-SQL - SELECT Statement - Online Tutorials Library
T-SQL - SELECT Statement - SQL Server SELECT statement is used to fetch the data from a database table which returns data in the form of result table. These result tables are called result-sets. Home
SQL Stored Procedures - Online Tutorials Library
SQL Stored Procedures. An SQL stored procedure is a group of pre-compiled SQL statements (prepared SQL code) that can be reused by simply calling it whenever needed.. It can be used to perform a wide range of database operations such as inserting, updating, or deleting data, generating reports, and performing complex calculations.
T-SQL - WHERE Clause - Online Tutorials Library
T-SQL - WHERE Clause - The MS SQL Server WHERE clause is used to specify a condition while fetching the data from single table or joining with multiple tables. Home Library
T-SQL - DELETE Statement - Online Tutorials Library
The SQL Server DELETE Query is used to delete the existing records from a table.. You have to use WHERE clause with DELETE query to delete selected rows, otherwise all the records would be deleted. Syntax. Following is the basic syntax of DELETE query with WHERE clause −