SQL Server - Page 5
25 May 2019
Use annotations in SQL Server
This article will show you how to use annotations in SQL Server statements.
25 May 2019
LITERAL in SQL Server
The article details how to use Literal - Hang (strings, integers, decimals, and datetime values) in SQL Server.
25 May 2019
Declare variables 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,
25 May 2019
SEQUENCE in SQL Server
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
25 May 2019
FUNCTION (Function) in SQL Server
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
25 May 2019
PROCEDURE (Procedure) in SQL Server
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
25 May 2019
INTERSECT operator in SQL Server
In SQL Server (Transact-SQL), INTERSECT operator is used to return records in both data sets or SELECT statements.
25 May 2019
EXCEPT operator in SQL Server
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.
25 May 2019
Query SUBQUERY child in SQL Server
The following article will show you how to use sub-queries in SQL Server along with syntax and examples.
25 May 2019
PIVOT clause in SQL Server
In SQL Server (Transact-SQL), the PIVOT clause allows cross tabulation to pass data from one table to another.
25 May 2019
Data types in SQL Server
Below are the data types (data types) in SQL Server, including character strings, numbers and times / dates.
25 May 2019
CREATE TABLE command in SQL Server
In SQL Server (Transact-SQL), the CREATE TABLE statement is used to create and define tables.
25 May 2019
Primary key PRIMARY KEY in SQL Server
Learn how to create, delete, disable or enable primary keys in SQL Server with syntax and examples.
25 May 2019
ALTER TABLE statement in SQL Server
In SQL Server, the ALTER TABLE statement is used to add columns, edit columns, delete columns, rename columns or rename tables.
25 May 2019
DROP TABLE command in SQL Server
In SQL Server, the DROP TABLE command is used to delete a table from the database.
25 May 2019
VIEW in SQL Server
The article explains how to create, update and delete VIEW in SQL Server with syntax and examples.
25 May 2019
GLOBAL TEMPORARY TABLE in SQL Server
The global temporary table Global Temporary Table in SQL Server (Transact-SQL) are tables created separately in SQL Server sessions,
25 May 2019
LOCAL TEMPORARY TABLE in SQL Server
This tutorial explains how to use LOCAL TEMPORARY TABLE in SQL Server with syntax and examples.
25 May 2019
Foreign Key foreign key in SQL Server
This tutorial introduces how to use Foreign Key foreign key in SQL Server with syntax and examples.