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.
Use the SQL Server Insert Into query with variables to insert data dynamically. How to build a SQL Server INSERT INTO statement with variables to make the code dynamic? This tutorial is like the first in the series for …
How to drop a SQL Server view with a T-SQL query? The DROP VIEW command allows you to simply delete an existing view with a T-SQL script run from SQL Server Management Studio (SSMS). The script below is an …
How do I clear all the data in a SQL Server table with a query? From SSMS, connect to the SQL Server database and use the TRUNCATE TABLE command to clear the data from the table. Note that the …
How to drop one or multiple SQL Server tables using a T-SQL script, and how to check the existence of the table? To drop a table with a SQL Server script, simply use the DROP TABLE command. Indeed, the …
To add a new view in a database, use this script written in T-SQL to create a view in SQL Server. A SQL view allows you to display specific columns of an existing table. Think of a view as …
How to list indexes in SQL Server database with one SQL query ? It can be very useful to display all database indexes. Indeed, to have an idea immediately at how this SQL Server database is optimized with indexes, …
How to disable an index in SQL Server? To disable an index for performance reasons, use this code and adjust it to your index and table names. For instance, let’s consider a large sales table, with million lines. Let’s …
Create an index in SQL Server to improve the performance of queries on tables and in clustered views. Two types of indexes exists, the clustered and the nonclustered one. To create a non-clustered index, use this example and adapt …
What is a SQL Server clustered index ? The definition of a SQL Server index is a structure, i.e. a file, stored physically in a disk. It’s like the master data file and the log data file that composes …
How to Check if table exists in SQL Server before to delete it ? How to drop it only if the existence check shows it already exists in the database to avoid errors, using the DROP TABLE keyword. Indeed, …
2011 - 2024 | Expert-Only.com
