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.
The XML query Method in SQL Server is very powerful. Indeed, XML is one of the most ubiquitous data formats, and its significance in SQL Server is no different. XML data can be stored in tables and queried just …
Introduction to SQL Server auto increment functionality. In SQL Server, the auto-increment feature provides a unique value for each row within a database table. It’s particularly useful when you need a unique identifier, such as a primary key. This …
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 …
© 2011 - 2026 | Expert-Only.com | All rights reserved
