parameter passing via global temp table with unique name
From: toylet (toylet_at_mail.hongkong.com)
Date: 04/03/04
- Next message: Joe Celko: "Re: Please help me populate a table"
- Previous message: toylet: "addressing a table indirectly"
- Next in thread: Aaron Bertrand [MVP]: "Re: parameter passing via global temp table with unique name"
- Reply: Aaron Bertrand [MVP]: "Re: parameter passing via global temp table with unique name"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 03 Apr 2004 23:13:51 +0800
Is there an easy to pass a result set (ie a table) from one stored
procedure to another via a uniquely named ##global_temp_table? Or is
there a better method?
The reason to use a uniquely named table is because the stored procedure
would be called by multiple parties. SO a fixed table name would cause
the callers to step on each other.
-- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:08pm up 8 days 15:22 load average: 1.30 1.35 1.32
- Next message: Joe Celko: "Re: Please help me populate a table"
- Previous message: toylet: "addressing a table indirectly"
- Next in thread: Aaron Bertrand [MVP]: "Re: parameter passing via global temp table with unique name"
- Reply: Aaron Bertrand [MVP]: "Re: parameter passing via global temp table with unique name"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
