The Microsoft T-SQL or Transact-SQL language is the SQL Server database programming language.
Indeed, T-SQL allows developers to cerate SQL Server queries and programs. It is specific to Microsoft databases.
It allows, for example, to declare variables, to create tables and temporary tables, views, functions and procedures. More generally, to run all the SQL commands offered by SQL Server.
T-SQL tutorial on how to create and run basic SQL Server stored procedures. To create a simple SQL Server stored procedure, use the CREATE statement. A SQL Procedure is nothing more than T-SQL code stored in a way that …
T-SQL tutorial to create a SQL Server stored procedure with input parameters and T-SQL variables. Create a SQL Server stored procedure with parameters and default values. The goal of SQL procedures is to group and schedule a set of …
When working with SQL Server databases, it’s common to need to check if a specific column exists in a table. For example in scenarios like database migrations, data imports, or when working with dynamic schema designs, where you typically …
How to update rows in a table directly from a Select statement in SQL Server? Technical tutorial to update a table directly from an select in SQL Server. Indeed, generally, in data integration projects, it often involves to update …
Script example to build a dynamic pivot query that adapts to the number of output columns. Writing a dynamic PIVOT query in SQL Server is a powerful way to transform and transpose data from rows into columns. Above all …
This tutorial is about how to split a delimited text into multiple independent columns with SQL Server. Working with comma or semi-colon delimited data often requires efficient and effective manipulation techniques. A common task is to split a single …
In this T-SQL guide, we’ll explore how to use table-valued parameters in a SQL Server stored procedure. It enables the passing of a table as a parameter and mot only its values like by using a select statement for …
Tutorial with T-SQL script examples to search for text inside one SQL Server Stored Procedure or multiple ones at the same time. In the world of database management, SQL Server stored procedures are a cornerstone. They encapsulate complex logic, …
T-SQL script example to alter an existing SQL Server stored procedure using ALTER PROCEDURE. How to alter a SQL Server stored procedure already in a Microsoft database ? Simply use the alter procedure command instead of the create command …
Introduction to SQL Server’s Stored Procedures listing using the system catalogs and views. This comprehensive tutorial will guide through the process of how to list all stored procedures in SQL server with increasing complexity as you read on. Stored …
© 2011 - 2026 | Expert-Only.com | All rights reserved
