How to import table using "INSERT" statement? | SQL Server interview questions

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

0 comments:

Post a Comment

Blogger news