Solved

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

Posted on 2007-03-30
4
197 Views
Last Modified: 2007-04-02
How can you view a # table in SQL Server 2005?
0
Comment
Question by:fsuedu
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 your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Delete from table 6 36
How to use TOP 1 in a T-SQL sub-query? 14 33
SQL query 4 27
Run SQL statement in Microsoft Access 9 9
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Backup & Restore 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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now