ajay raju

ajay raju

  • NA
  • 395
  • 0

select and insert stored procedure in sqlserver

May 27 2010 8:27 AM

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. 

Answers (3)