Interested to Buy Any Domain ? << Click Here >> for more details...
Creating Tables Using SELECT
- 1 Answers
- 3375 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is a filestream?
Can we call stored procedure in trigger?
Why are views required in the sql server or in any other database?
What is thr feature of change data capture?
What do you need to connect php to sql server?
How do I create a stored procedure in sql server?
Is mysql the same as sql server?
What is snapshot replication?
How do I run a trace in sql server?
How to change the ownership of a schema in ms sql server?
What is the log shipping?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
