Explain me the SELECT INTO statement?
Submitted by: MuhammadThe SELECT INTO statement copies data from one table into a new table. The new table will be created with the column-names and types as defined in the old table. You can create new column names using the AS clause.
SELECT * INTO newtable FROM oldtable WHERE condition;
Submitted by: Muhammad
SELECT * INTO newtable FROM oldtable WHERE condition;
Submitted by: Muhammad
Read Online Database Developer Job Interview Questions And Answers
Top Database Developer Questions
☺ | Please explain what is Database Testing? |
☺ | Explain me what are the different DDL commands in SQL? |
☺ | Tell us what is a temp table? |
☺ | Tell me what is a Composite PRIMARY KEY? |
☺ | Do you know SQL Data Types? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |