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 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 …
How to transform data from rows into columns with a SQL Server query? Follow this SQL tutorial and query examples on how to use the SQL Server PIVOT operator to convert rows of data into columns. But the syntax …
To audit a MSSQL database and its tables, it is common to want the list of tables in the form of a table or an Excel spreadsheet. This SQL query allows you to list all the tables in a …
What is the syntax of the IF THEN ELSE in SQL Server code and how to use it ? Transact-SQL comes with rich features allowing dynamic and also robust data manipulation, and among these, the IF THEN ELSE statement …
To display the full month name 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 letters, abbreviations, and …
Learn 4 different methods to get the difference between two dates using SQL Server time functions. With the SQL Server time functions, it is possible to calculate the difference between two dates in hours, minutes, and seconds. But this …
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 example. …
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 to …
© 2011 - 2026 | Expert-Only.com | All rights reserved
