How to import table using “INSERT” statement?

 Posted by ArticlesMaint on 10/3/2009 | Category: Sql Server Interview questions | Views: 7508

I have made a new temporary color table which is flourished using the below SQL. Structures of both the table should be same in order that this SQL executes properly.

INSERT INTO TempColorTable

SELECT code,ColorValue
FROM ColorTable

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response