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 transform data from rows into columns using 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 …
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 …
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 …
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 that …
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 of …
2011 - 2024 | Expert-Only.com
