Table Variable (Create,Insert,Select,Update)

-Table variable are alternative to temporary table and used for lesser sets of records. If large then temporary tables are used (#tempTable).

...Creating Table Variable

DECLARE @tempTable(

     userID int,

     userName nvarchar(50)

)

...Inserting into Table Variable

INSERT INTO @tempTable (userID , userName)

     SELECT userID, userName FROM UserInfo

...Selecting from Table Variable

SELECT * FROM @tempTable

...Updating Table Variable

UPDATE @tempTable

     SET userName =  'Newton'

WHERE userID = 1