Temporary results used by SP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Tue, 4 Jan 2005 03:59:05 -0800

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: How to use SQL "LIMIT" keyword against an MDB file
    ... that it will work with an MSAccess MDB file. ... Except you've just "solved" his issue with a database redesign. ... from MySQL to Access in the first place. ... into <temp table with autonum> ...
    (comp.lang.php)
  • Re: Do Transactions guard against corruption?
    ... the original MDB file is left untouched ... the %TEMP% directory of your workstation. ... file edits into the real MDB file. ... The purpose of transactions is to make sure that operations that are ...
    (microsoft.public.access.modulesdaovba)
  • Re: create table scripts
    ... regular basis then: you might have a design problem; ... hard to make a DDL command using CREATE TABLE. ... pulling down a temp table on a regular basis, ... and corruption of the mdb file. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: CREATE TEMPORARY TABLE
    ... When I've used a temp table in SQL Server I've ... creating a third MDB file on the local workstation, ... Since the MDB file is local to ... on their computer automatically differentiates between users. ...
    (microsoft.public.access.tablesdbdesign)
  • OLEDB performance in ADO.NET
    ... I am using OLEDB to log real-time data to a local mdb file from my C# ... I will be generating a new .mdb file every 1 hour on the local machine ... StringBuilder crtTableCmd = new StringBuilder; ...
    (microsoft.public.dotnet.framework.adonet)