Loading

SQL Server Transact Basic to Expert - Create a table variable

Karthikeyan Anbarasan

Comments

Join the conversation! Your thoughts help the community grow.

This blog shows how to create a table variable in sql server

Syntax:
DECLARE @TableName TABLE
(columnname <data_type> [ NULL | NOT NULL ] [ ,...n ])

Example:
DECLARE @Empsal TABLE
( EmpID int NOT NULL PRIMARY KEY,
Empsal money NOT NULL,
EmpCount int NOT NULL)