How to view #temp tables in vs.net (stored procedures)

From: msnews.microsoft.com (nospam_at_notvalid.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 16:01:35 -0400

When you step into a stored procedure using vs.net, you get all the debug
variables, except temp tables (like INSERT INTO #list (id) SELECT id FROM
members WHERE...).

Is it possible to view the temp tables?

-Max

Relevant Pages

  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedures in SE 7.3
    ... My end goal to write a stored procedure to be used by Lotus Enterprise ... Integrator (LEI). ... into temp t1; ... from bmdata, t1 ...
    (comp.databases.informix)
  • RE: Strange issue while executing sql server sp
    ... field is the one where truncation is occurring as my temp table field size is ... I have a simple stored procedure in sql server 2005 express version. ... ,finishdate datetime ...
    (microsoft.public.sqlserver.programming)
  • Re: How to navigate recursive stored procedures results
    ... connection is inherited by the next user, ... beforehand so any residual #Temp tables would be dropped. ... the identity is not "flow"ing to the SQL Server - ... union a SQL query and the results of a stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQLdatasource delete with parameter output
    ... Also you can possibly debug and step into your stored procedure. ... @SiteProjectID Int, ... @MeasureID Int, ...
    (microsoft.public.dotnet.framework.adonet)