Any one knows how to create a temp table based on the information of
existing table. What's the easiest way?
Weiguo
by WZHAN » Sat, 11 Jan 1997 04:00:00
Any one knows how to create a temp table based on the information of
existing table. What's the easiest way?
Weiguo
by Karl Costenbade » Sun, 12 Jan 1997 04:00:00
SELECT * INTO #tmp FROM table_name
> Any one knows how to create a temp table based on the information of
> existing table. What's the easiest way?
> Weiguo
by Neil Pik » Mon, 13 Jan 1997 04:00:00
Weiguo,
Use select into. If you don't want any rows, just use WHERE 1=0 to ensure that
no rows match.
Protech Computing Ltd (MS Solution Provider)
Using Virtual Access 3.52 build 159c (32-bit) on NT 4.0 SP2
1. create a temp table with an existing table stucture
Hi freinds,
SQL 2000 WIN2000
I need to create a temp table <temp_agency> base on <agency> table
structure!
Is there any fast way to create temp table ? Or I have to specify each
field?
Thanks in advance,
Patrick
2. Problem killing open server with SIGTERM
3. create temp table: -261 Cannot create file for table - Not owner
4. CA. Oracle DBA's and Developers needed
5. Creating temp table identical to an existing one
6. Oracle DBA need in Rhode Island
7. Dynamically creating a PK based on an existing table
9. Create SQL insert Scripts based on existing data in table
10. Difference between create table #temp and ##temp ?
11. Create table temp or select into temp.
12. How do I create a temp table to join with another table
13. verifing whether a table with same name exist or not before creating new table