Insert data from one table to another

CGN007
Posted by CGN007 under Sql Server category on | Points: 40 | Views : 993
Syntax
INSERT INTO target_table[(<column-list>)] SELECT [(<column-list>)] FROM source_table

insert into EmployeeMaster select * from EmployeeMas

Comments or Responses

Login to post response