Solved

How can you view a # table in SQL Server 2005?

Posted on 2007-03-30
4
203 Views
Last Modified: 2007-04-02
How can you view a # table in SQL Server 2005?
0
Comment
Question by:fsuedu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 20

Expert Comment

by:Sirees
ID: 18825806
You can view using Microsoft SQL Server Mangement studio.

Do you have SQL Server 2005 client tools installed?
0
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 18825843
Or just
Select * from #tablename

But it can only be viewed by the user and session that created it!  Use ##table for a temp table that can be viewed by someone else.
0
 

Author Comment

by:fsuedu
ID: 18825846
Thanks where would I see SQL Server 2005 client tools installed?


JK
0
 
LVL 4

Expert Comment

by:eozz_2000
ID: 18827155
dgmg is fully right, you can only view the # temp tables when you don't close the connection that create it, with ## temp tables any user could see and change it
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Optimize the query 5 51
SQL Syntax 24 54
SSRS: Why is Visual Studio stripping these properties? 2 40
Need help separating values from a column and creating a new record 6 45
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question