create table as select

Question

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

JeffB Hall of Fame Points: 3541 More actions · Answer 1

this creates a temporary table #a:

select name

into #a

from sysobjects

select * from #a

alexia-294642 SSChasing Mays Points: 600 More actions · Answer 2

maybe you could try like this in your SP or query:

create table #temp(@field1 int,@field2 varchar(10))

insert into #temp

select a,b from tableFrom

select * from #a

then, when you're not using the table again,

drop table #a

Vee Hall of Fame Points: 3028 More actions · Answer 3

in T-SQL You can do it with the following syntax

select * into from

example

select * into mytable from sysobjects

Vee Hall of Fame Points: 3028 More actions · Answer 4

n T-SQL You can do it with the following syntax

select * into [new_table_name]from [table_name]

example

select * into mytable from sysobjects

You Store, I Manage

tp_id Valued Member Points: 73 More actions · Answer 5

thanx yaar ur tip was awesome ...

i tried it .. n it worked

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 6

SSChampion

Points: 10207

November 29, 2007 at 4:53 am

select * into new_table from old_table

Avaneesh -388582 SSChasing Mays Points: 657 More actions · Answer 7

Hi,

you can make use of temporary table as follows:

select * into #TempTable from SourceTable

Regards,

Avaneesh.

Cookies on SQLServerCentral