Re: Temporary results used by SP

From: FGItaly (FGItaly_at_discussions.microsoft.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 05:25:06 -0800

This is OK if the operation of step b) are executed by SP in Sql Server, but
if I use VB.NET and ADO.NET I can't see the temp table.

"Tibor Karaszi" wrote:

> You can create the temp table prior to the execution of the stored procedure and have the sp insert
> etc the data in it and then use the data after the execution of the procedure.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
>
> "FGItaly" <FGItaly@discussions.microsoft.com> wrote in message
> news:4CA935A9-232F-49BD-8C8F-76FE49F24B3B@microsoft.com...
> > In a MS Access Application you can use the "link table" to connect to a
> > common mdb file for the main database and a local mdb file for temp
> > tables/results.
> >
> > How to reproduce this scenario in Sql Server ?
> > From VB.NET these are the steps I would like to perform:
> > a) call a SP to do the heavy works, querying multiple tables and fill the
> > result table "xyz"
> > b) use the data in "xyz" to do something
> > c) drop the "xyz" table
> >
> > I can't use #temp tables cause they will be dropped at the end of the SP. If
> > I use a permanent table, what about if two or more users do the same
> > operation ? And what about performance ?
> >
> >
>
>
>

Relevant Pages

  • Re: Slow UPDATE and DELETE on SQL Server 2000
    ... I've increased the size of the TempDb database and noticed ... When I ran the update query I got an error message about not being ... I did read the execution plans incorrectly. ... > SQL Server process, memory, as well as the SQL Server specific counters. ...
    (microsoft.public.sqlserver.server)
  • Re: ADO/MDAC on Terminal Server
    ... XP database system to SQL Server 2000. ... front end is running on the Terminal Server. ... MDB file due to fixes and modifications, ... "missing reference" error as the MDB file opens up. ...
    (microsoft.public.data.ado)
  • Re: DTS ActiveX Scripting
    ... SQL Server Agent Account if the owner of the job is a SQL Server sysadmin ... As you can see the first> ActiveX script runs ok. ... DTSRun: Loading... ... ActiveX Scripting> encountered a Run Time Error during the execution of the> script. ...
    (microsoft.public.sqlserver.dts)
  • Re: newbie problem: updating an access db
    ... modifying the code to use SQL Server it still exhibited the same ... changed the path to the supplied access .mdb file in the web.config ... the delete and update commands, so now they just test whether Adnum= ?. ... get this code to work, I don't want to start modifying it to use MSSQL, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to capture SQL statement messages in DTS log file
    ... I have several SQL Server 2000s and a couple of SQL Server 2005 servers ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)