Program

The article details how to use Literal - Hang (strings, integers, decimals, and datetime values) in SQL Server.

SQL Server fully exists the concepts of data types, variables and declarations of variables as other programming languages. The article will learn how to declare a variable,

Sequence is often used in databases because it is necessary for many applications. The article will provide syntax and examples of how to create and delete the sequence and its

The function in SQL Server is stored in the database so you can pass the parameters as well as return the values. The article will give you the syntax and examples of how to

Procedure is a program in the database that contains many statements that you save for later use but have different points from Function. The article will give you the syntax and

In SQL Server (Transact-SQL), INTERSECT operator is used to return records in both data sets or SELECT statements.

The EXCEPT operator in SQL Server is used to return the rows in the first SELECT statement that are not returned in the second SELECT statement.

The following article will show you how to use sub-queries in SQL Server along with syntax and examples.

In SQL Server (Transact-SQL), the PIVOT clause allows cross tabulation to pass data from one table to another.

Below are the data types (data types) in SQL Server, including character strings, numbers and times / dates.

In SQL Server (Transact-SQL), the CREATE TABLE statement is used to create and define tables.

Learn how to create, delete, disable or enable primary keys in SQL Server with syntax and examples.

In SQL Server, the ALTER TABLE statement is used to add columns, edit columns, delete columns, rename columns or rename tables.

In SQL Server, the DROP TABLE command is used to delete a table from the database.

The article explains how to create, update and delete VIEW in SQL Server with syntax and examples.

The global temporary table Global Temporary Table in SQL Server (Transact-SQL) are tables created separately in SQL Server sessions,

This tutorial explains how to use LOCAL TEMPORARY TABLE in SQL Server with syntax and examples.

This tutorial introduces how to use Foreign Key foreign key in SQL Server with syntax and examples.

This article explains how to use Foreign Key with Cascade Delete in SQL Server with syntax and examples.

The following tutorial will explain the Foreign Key foreign key with the Set Null On Delete constraint in SQL Server.