Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jrobin747
Starting Member
48 Posts |
Posted - 2013-08-15 : 15:12:51
|
I working with temp tables for the first time.I've created the table #TempDashboarddefined the columns and created queries to fill the records usingINSERT & UPDATE I've been pointed to an example in a stored procedure. I sorta understand what I read in the stored procedure. Mimicing what I see, I have no idea if I am doing it correctly.I'm using SQL Server Management Studio 2008. How do I test/see if I am filling the temp table correctly? |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-15 : 16:09:36
|
After you fill the temp table, do a SELECT * FROM #TempDashboardThat should show you what you put into the table.If you create a temp table, it goes out of scope when you exit the stored procedure. |
|
|
|
|
|