select and insert stored procedure in sqlserver

Question

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 enoenamesal from emp insert into emp (enoenamesal) values (here we insert above selected emp values) please give example code. Thanks.

Venkatesan Jayakantham · Answer

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

Crish · Answer

hi try below query insert into emp (enoenamesal) values ( select enoenamesal from emp ) thanks

PJ Martins · Answer

You can also write an insert statement as such: 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