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.
Practical guide on how to use the SQL Server SQLCMD tool. The tutorial about the SQLCMD examples is divided into different sections, providing a wide overview of various functionalities, use cases, and handy tips with the command line tool. …
SQL Server, a versatile relational database management system, comes packed with features that cater to developers and database administrators. One such feature, often debated in its utility, is the “cursor”. Here, we’ll explore how to effectively use cursors in …
How to create and use SQL Server triggers ? MS SQL triggers are powerful database objects that monitor and respond to specific events. In this guide, we’ll explore what triggers are, why they’re used, and how to effectively implement …
Managing data efficiently is at the core of any well-structured database system. When working with Microsoft SQL Server, an integral part of this management is the effective use of SQL Server variables. These variables allow for the temporary storage …
SQL Server table valued functions with T-SQL practical examples. Table-valued functions in SQL Server are a type of user-defined function that return a table data type. These functions are a powerful tool that can help organize your SQL code, …
Use the CONCAT function in SQL Server to join two or more strings into one unique string. The SQL Server CONCAT function takes up to 255 input arguments, which can be any valid expression as long as they are …
The SQL Server CASE statement is a conditional operation that can be used to provide if-then-else type of logic to T-SQL queries. The CASE statement can be used in SQL Server queries involving calculations, data transformation, and more. 1. …
Practical T-SQL scripts examples to manage XML data in SQL Server. How to use the XML data type in SQL Server tables ? To start, XML stands for eXtensible Markup Language, it is a standard IT format for storing …
T-SQL transactions tutorial with practical examples using the BEGIN, COMMIT and ROLLBACK. T-SQL transactions are a sequence of one or more operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, …
Add new sample SQL Server tables using the create table statement and SSMS. Here is an example of a SQL Server Create Table script to create a customer or sales table. This T-SQL code is a Data Definition Language …
2011 - 2024 | Expert-Only.com
