How to Work with Table Variables in Transact-SQL
In this article I am going to explain about how to work with table variable in Transact-SQL.
Transact-SQL (T-SQL) is Structured Query
Language and it is Microsoft's and Sybase's proprietary. Transact-SQL is
originally developed by IBM for querying, altering and defining relational
database. Transact SQL is also known as T-SQL. T-SQL supports many feature like
variables, loops, conditions and exceptions.
Table variable is used to store an entire
result set rather than a single value. DECLARE statement is used to
create a table variable. All the name of table variable in T - SQL start with at
Syntax for declaring a variable in T-SQL
DECLARE @table_name data_type
WHERE vendorid IN
SELECT * FROM @vendorinfo