hi,
in my project i need one procedure i.e., first i select one row and that row is inserted into that table, how to write single stored procedure todo this.
ex: select eno,ename,sal from emp
insert into emp (eno,ename,sal) values (here we insert above selected emp values)
please give example code.
Thanks.
Loading
Venkatesan JayakanthamPosted Jun 8, 2010, 1:59 AM
create table sample_table (id int, dat datetime)
insert into sample_table values(1,getdate())
create table sample_table1 (id int, dat datetime)
Your query,
insert into sample_table1
select * from sample_table
Cheers,
Venkatesan Prabu .J
CrishPosted May 27, 2010, 2:03 PM
try below query
insert into emp (eno,ename,sal) values (select eno,ename,sal from emp)
thanks
PJ MartinsPosted May 27, 2010, 10:29 AM
insert into emp (eno, ename, sal)
select eno, ename, sal from emp
instead of using values, simply place the select statement after the insert statement