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 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 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
How to update the same column in the same table of another line with SQL Server? Example of code to update the same SQL Server column on another line, on the same table. This row must be identified
How to split a string after a particular character with the SQL substring function? For example, use the substring function to split a string like file.txt to separate the file name from its extension after the dot character.
How to modify a SQL Server function with Alter Function ? How to update the code of an SQL Server function without deleting it? The solution is to update its definition using the SQL Server Alter Function command.