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 script examples to modify SQL Server tables using ALTER TABLE statements. How to modify a SQL Server table with a simple script, using the ALTER statement? Simply connect to the server hosting the instance using SSMS for …
How to modify a table in SQL Server using ALTER TABLE ? Read More »
To pass a list of integer values to a stored procedure in SQL Server using a Table-Valued Parameter, also abbreviated as TVP, is a clean and efficient approach. Here’s a step-by-step tutorial on how to use it with …
Pass a list of values as a parameter to a stored procedure in SQL Server Read More »
Execute SQL Server stored procedures with one or multiple input parameters. Depending on the implementation of the T-SQL code, execute SQL Server stored procedures with input parameters by providing values or default ones will be used. First you …
How to execute a stored procedure with parameters in SQL Server ? Read More »
Different solutions to convert a date stored in a text to a date format using T-SQL functions. When working with data in SQL Server, you may encounter situations where you must convert dates that are stored as strings …
How to convert a string to a date format in SQL Server ? Read More »
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 …
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 …
How to create a SQL Server stored procedure with parameters ? Read More »
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 …
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 …
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 …
How to split a delimited string with XML or STRING_SPLIT functions with SQL Server ? Tutorial on how to split a string with delimiter in SQL Server, usually semicolons, into one column using SQL Server. With a T-SQL …
Split delimited string into one column in SQL Server Read More »
