Insert Into statement

[jason]

Hi, Every body,

Is there anyway that we can use insert into statement to insert data into the first row of a table, or initialize the column with the new inserted data.

Thanks in Advance,

[paul]

not entirely sure what u mean ? Can u be more specific.

------------
jason at 3/27/01 11:19:59 AM

Hi, Every body,

Is there anyway that we can use insert into statement to insert data into the first row of a table, or initialize the column with the new inserted data.

Thanks in Advance,

[jason]

Hi, Paul,

What I want to do is I need to insert some data into a table from another one, but I want the inserted data to be in the first row, it means the inserted data will overwrite the original data in the first table.

Thanks a lot,


------------
paul at 3/27/01 11:51:17 AM


not entirely sure what u mean ? Can u be more specific.

------------
jason at 3/27/01 11:19:59 AM

Hi, Every body,

Is there anyway that we can use insert into statement to insert data into the first row of a table, or initialize the column with the new inserted data.

Thanks in Advance,

[Chris]

You will have to use and update statement to accomplish your mission.

------------
jason at 3/27/01 12:17:08 PM


Hi, Paul,

What I want to do is I need to insert some data into a table from another one, but I want the inserted data to be in the first row, it means the inserted data will overwrite the original data in the first table.

Thanks a lot,


------------
paul at 3/27/01 11:51:17 AM


not entirely sure what u mean ? Can u be more specific.

------------
jason at 3/27/01 11:19:59 AM

Hi, Every body,

Is there anyway that we can use insert into statement to insert data into the first row of a table, or initialize the column with the new inserted data.

Thanks in Advance,

[jason]

Hi, Chris

Could you please give me an example of the statement? I would be very apprecaited.

Thanks,


------------
Chris at 3/27/01 2:14:24 PM


You will have to use and update statement to accomplish your mission.

------------
jason at 3/27/01 12:17:08 PM


Hi, Paul,

What I want to do is I need to insert some data into a table from another one, but I want the inserted data to be in the first row, it means the inserted data will overwrite the original data in the first table.

Thanks a lot,


------------
paul at 3/27/01 11:51:17 AM


not entirely sure what u mean ? Can u be more specific.

------------
jason at 3/27/01 11:19:59 AM

Hi, Every body,

Is there anyway that we can use insert into statement to insert data into the first row of a table, or initialize the column with the new inserted data.

Thanks in Advance,