How to update a table using an existing table data?

 Posted by CGN007 on 7/20/2012 | Category: Sql Server Interview questions | Views: 1034 | Points: 40

The SELECT INTO statement selects data from one table and inserts it into a different table.
SELECT [(<column-list>)] INTO target_table FROM source_table

select * into EmployeeMasTemp from EmployeeMas

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response