ms sql server 2005 - get results from #temp table
Posted on 2011-10-14
I am creating a sproc using #temp table and I want to see what is loaded into the #temp table before it is destroyed at the end
I try this to get the data to the results window:
select col1,col2,col3 into #temp_table (select...from....
select * from #temp_table
how can I print out the data in the columns from the #temp_table to the results window when I run the code??