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.
Find duplicate records on one or multiple columns in SQL Server is a crucial task for maintaining data integrity and accuracy in your databases. Duplicates can skew your analysis, leading to potentially costly business decisions. This guide provides a …
Using this T-SQL example, you can easily transform columns into rows with just one step thanks to the SQL Server UNPIVOT function. It is the exact opposite of the PIVOT query. In this example, only the six first months …
How to split a simple string stored in a variable after a specific character using SQL Server functions? For example, use the substring function to split a string like file.txt to separate the file name from its extension after …
Languages are a significant part of human history, culture, and communication and different languages offer unique insights into diverse worldviews and traditions. The following are ten of the most widely spoken languages around the world. Each language is accompanied …
Transact-SQL query to display the list of all table names from a database with size and disk space used on the server. Listing SQL Server table size and disk space can be very convenient specially to analyse the disk …
Tutorial with T-SQL code examples to execute a SQL Server stored procedure with one or multiple input parameters. Depending on the T-SQL code, execute a procedure with parameters in SQL Server by providing mandatory values or default ones will …
The functionality to split text into different lines based on a separator is available natively from SQL Server 2016 and later. In order to split text with separator into lines, I have been using T-SQL user-defined functions for years …
How to split data from a unique string in line with a delimiter into one column using SQL Server ? Tutorial on how to split a delimited string into one unique column in SQL Server, the delimiter used is …
How to call SQL Server functions from Transact-SQL scripts? Tutorial on how to call a SQL Server function using T-SQL scripts, with and without parameters. Indeed, the T-SQL syntax for calling a function is different from calling a stored …
In a previous technical article, we learned the PIVOT query with one unique fixed column, this time we’ll use a more complex use case, a SQL Server PIVOT case with multiple fixed columns. Indeed, in this different example, the …
2011 - 2024 | Expert-Only.com
