Answer Posted / mohammadali.info
*SELECT...INTO essentially combines CREATE TABLE and SELECT in a single statement. The AS clause can be used to change the column labels and thus control the column names in the new table. The other commands in the figure show the new table's structure and contents.
-SELECT firstname, lastname, city, state
INTO newfriend
FROM friend;
-SELECT...INTO tablename can also be written as CREATE TABLE tablename AS SELECT.... The preceding query can then be rewritten as
CREATE TABLE newfriend AS SELECT firstname, lastname, city, state FROM friend.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Write the syntax for stuff function in an sql server?
What is page-level compression?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Explain for xml explicit mode?
What do you mean by data manipulation language?
What are the system database in sql server 2008?
What is difference between rownum and rowid?
What is multilevel indexing?
What are tables in sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to find the service pack installed? : sql server database administration
List the various tools available for performance tuning?
Explain what is the purpose of sql profiler in sql server?
What is NOT NULL Constraint in sql server 2012?
What do you mean by SQL injection attack?