programplug Logo



SQL Table Variable

SQL;



SQL Basic

» SQL Introduction

» What is SQL?

» What is RDBMS?

» Syntax In SQL

» Data Type In SQL

» Operators In SQL

» Truncate

SQL Table

» Table

» Table Variable

» Create Table

» Copy Table

» Alter Table

» Drop Table

SQL Commands

» Commands In SQL

» Create Statement

» Select Statement

» Delete Statement

» Drop Database

SQL Clause

» WHERE Clause

» AND Clause

» OR Clause

» WITH Clause

SQL Keys

» Primary Key

» Foreign Key

» Unique Key

»Null Value

» Not Null Value

SQL Joins

» Joins

» Inner

» Full

» Left

» Right

SQL Order

» Order By

Table Variable In SQL


The Table variable in SQL is used to create, rectify, rename, copy and remove tables. Table variable was intvented by Microsoft.The SQL server 2000 was introduced to be alternative in temporary tables.
In variable we store the result and records in temporary.

CREATE TABLE "table_name" 
CREATE TABLE "table_name"
("coloumnX" "table_1"
"coloumnY" "table_2"
....
"coloumnN" "table_3");

Table variable never be used as input or output parameter.
Once the transaction is rolled back the data associated with table is never rolled back again.