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
by Patric » Sat, 29 Dec 2001 05:06:16
Thanks in advance,
Patrick
by oj » Sat, 29 Dec 2001 05:09:53
select top 0 *
into temp_agency
from agency
-oj
Quote:> 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
1. create a temp table based on existing table
Any one knows how to create a temp table based on the information of
existing table. What's the easiest way?
Weiguo
2. Informix and IIS ASP script problem
3. create temp table: -261 Cannot create file for table - Not owner
5. Creating temp table identical to an existing one
7. How do I create a temp table to join with another table
8. Difference between create table #temp and ##temp ?
9. Create table temp or select into temp.
10. verifing whether a table with same name exist or not before creating new table
11. Creating table having structure same as that of existing table
12. Create Table from existing table