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.

What is the difference between primary key and unique constraints?

0 Answers  

---

How can I create a report based on a query? : sql server management studio

0 Answers  

---

What happens if date-only values are provided as date and time literals?

0 Answers  

---

What is the difference between getdate and sysdatetime?

0 Answers  

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

What is page in sql server?

0 Answers  

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

What is normalization and its types?

0 Answers  

---

How to edit table in sql server 2017?

0 Answers  

---

How can change procedure in sql server?

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---