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 create a SQL Server stored procedure to return values with OUTPUT? This simple T-SQL example returns values through output parameters. Setting up, instantiating, and using the output parameters of a stored procedure is similar to that of …
How to drop a SQL Server stored procedure without error using the existence check? To drop a SQL Server stored procedure and avoid errors, first test the existence of the procedure in the SQL Server database to condition the …
Query to store the contents of a SQL Server column in a variable, inline and with delimiters. SQL tutorial to read and store the result from a SQL Server column in a variable, and with separators. In some cases, …
How to format a SQL query automatically with a free online service? Format a SQL query automatically can be time-consuming and tedious, especially on existing projects that are not developed according to the rules of the art. There is …
Example queries with the SQL Server SELECT function to select, filter and display data. This tutorial offers an extensive collection of SQL Server SELECT query examples to display and filter data from tables. The SELECT query is a powerful …
How to test and then drop a SQL Server view, if it exists in the database? Here is how to test the existence and drop a SQL Server view with a T-SQL script. Use this script as an example …
How to execute a T-SQL procedure from a text with a hard coded variable? Tutorial to manage and execute a T-SQL procedure with hard coded variables, i.e. stored in a string. Indeed, a normal execution does not work with …
Another IT and more specifically a database tutorial on how to drop an index from a table in SQL Server. An index is associated with an existing table in a database. It can be a relational or transactional database. …
How to reorganize a SQL Server index? This operation defragments the bottom level of the indexes by physically reordering the pages, from left to right. The reordering operation also compacts the pages of the index. To better understand this, …
How to encrypt a View in SQL Server using the create view statement and the encryption option? How to create a SQL Server view with the encryption option? The WITH ENCRYPTION option allows you to hide the view code. …
© 2011 - 2026 | Expert-Only.com | All rights reserved
