SQL Server left join examples
With this tutorials on SQL Server left join examples, it is possible to extract data from two or more SQL tables. The query is based on the relationships between the objects. MS SQL left joins indicate how the …
T-SQL
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.
Manage SQL Server user defined functions
How to manage SQL Server user defined functions ? SQL Server user-defined functions are very useful when starting T-SQL development. You need to use them very often so you have to learn the right syntaxes and avoid errors. …
How to create a SQL Server function with a script ?
Example of T-SQL code to create a simple SQL Server user defined function. Tutorial to create a simple SQL Server function with a T-SQL script. You can use the code provided as a syntax checklist or an example …
How to create a SQL Server function with a script ? Read More »
Modification date of SQL Server tables and views with a T-SQL query
How to display the modification date of SQL Server tables? This SQL Server query example uses the system tables to detect and display the latest modification date of SQL Server tables, or views. It displays the creation date …
Modification date of SQL Server tables and views with a T-SQL query Read More »
