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.
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 …
How to build a pivot query in SQL Server to transform rows into columns? Follow this tutorials and query examples on how to use the SQL Server PIVOT operator to convert rows of data into columns. The SQL …
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 …
Use a table parameter in a Stored Procedure in SQL Server Read More »
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 …
How to search text in a stored procedure with SQL Server ? Read More »
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 …
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. …
These simple SQL Server Stored procedure examples are powerful tools that can simplify your database development work. For example when dealing with complex business logic embedded into the SQL code. A stored procedure is a group of Transact-SQL …
How to display the full month name, i.e. in all letters from a date using a SQL Server query? The SQL Server database offers T-SQL methods to display the month name in diverse formats, including name in all …
Code examples for adding a primary key constraint to a SQL Server column to avoid inserting the same key several times. How to create a table with a primary key in SQL Server? A database primary key is …
How to fix the SQL Server Error Implicit conversion from data type XML to NVARCHAR is not allowed? How to convert XML into NVARCHAR with SQL Server? To avoid the SQL Server error conversion from XML to NVARCHAR. …
Implicit conversion from data type XML to NVARCHAR T-SQL error Read More »
