How to insert/copy rows from one table to another?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

siluctc Mr or Mrs. 500 Points: 539 More actions · Answer 1

Hi,

The Sql code will be

insert into tbDestination

select 1,col from tbSource

arun.sas SSChampion Points: 11831 More actions · Answer 2

descentflower (7/1/2009)
How would i do that with an efficient way?

Hi,

What you mean the efficient way???

create tbDestination

(

col1 int default as 1,

col2 int

)

insert into tbDestination (Col2)

select * from tbSource

create tbDestination

(

col1 int ,

col2 int

)

insert into tbDestination(1,Col2)

select * from tbSource

ARUN SAS

Pandian S SSChasing Mays Points: 625 More actions · Answer 3

SELECT 1 'Col1',col 'Col2' INTO tbDestination FROM tbSource

descentflower Ten Centuries Points: 1227 More actions · Answer 4

Ten Centuries

Points: 1227

July 1, 2009 at 2:53 am

Thanks for your help