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.
How to insert or remove SQL Server line breaks, also called carriage returns in strings, columns and variables? Transact-SQL scripts to manage line breaks in SQL Server strings stored in columns or variables. In other words how to remove …
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 …
2011 - 2024 | Expert-Only.com
