Declaring Table Variable using Existing Table Schema in Sql

Question

I want to declare a Table Variable in my stored procedure using existing tables schema.

I have a Table, say TableA, which has about 30 columns. I want to declare a Table Variable using the same columns just as we declare a Temporary Table.

For instance, I can declare a Temporary Table using the schema like this:

SELECT TOP 0 * INTO #Temp_TableA FROM TableA

Can I similarly declare a Table Variable???

Answer 1

From MSDN:
No, table variable is a variable as name suggests so you need to declare it before you can use it like all other T-SQL variables and you need to use INSERT INTO

DECLARE @MyTable TABLE(
ID INT NOT NULL,
Data varchar(30) NOT NULL
);
INSERT INTO @MyTable
SELECT ID, data
From <table>

You can also use a temporary table in your stored procedure. Just add to the beginning of stored procedure this code:

if object_id('tempdb..#TableA') is not null drop table #TableA