Table Variable

Table Variable tool used in SQL when you need a table that will be removed after you are out of the scope.  This way you only use temporary memory.

Syntax for Table Variable:
Use BLOG
declare @TibetanYaks Table(
        YakID int
       ,YakName char (30))


//Special Note of the @ before the table name