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 table partition in SQL Server? Let’s consider a large table with Sales data. So, this table have a column that stores the year of the sale and the table stores millions of lines. Let’s consider …
How to Create SQL Server partitioned views to group data from multiple tables? Find examples of scripts to create views that points to four or more different tables. In this example, each Sales table would contain the sales of …
How to list user defined table types in a SQL Server database? First of all, users declare User Defined Table Type as a particular table structure in the database. This UDT is reusable in database, it is not a …
How to check the last date a table was updated on a SQL Server database? Check the last access and update with a simple SQL query? Thanks to the SQL Server relational database management system tables, a query allows …
How to alter a SQL Server view with a T-SQL script? This code example allows you to modify an existing view. All you must do is use the common ALTER VIEW command. For example, to delete a column from …
How to write an insert or update query with SQL Server, also called SQL upsert? Here are two different, quick and easy solutions to write an “UPDATE OR INSERT” query. In other words, avoid the SQL Server error “Cannot …
How to modify a column in a SQL Server table with a script? Tutorial to modify a SQL Server column with a T-SQL ALTER TABLE and ALTER COLUMN command. This SQL code allows you to modify the structure of …
Use the SQL Server SUBSTRING function to split a text column or a variable, copy and adapt the examples using the string, start and length arguments. Example queries on how to use the SQL Server SUBSTRING function to cut …
How to insert data table using insert into queries called from a SQL Server Select? There are 3 solutions to run an INSERT INTO query within a SQL SELECT. The first solution is to insert directly the data with …
How to run multiple SELECT queries on the same SQL Server CTE? Is it possible to execute several selection queries on a CTE, i.e. to call a SQL Server CTE multiple times in the same stored procedure for example? …
2011 - 2024 | Expert-Only.com
