Create PROCEDURE xyz
as
select * into #employee1 from employee where 1=2
select * from #employee1
exec xyz
Here employee original Table
#employee1 temporary table
OUTPUT ONLY BE THE STRUCTURE OF THE EMPLOYEE TABLE
as
select * into #employee1 from employee where 1=2
select * from #employee1
exec xyz
Here employee original Table
#employee1 temporary table
OUTPUT ONLY BE THE STRUCTURE OF THE EMPLOYEE TABLE