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 it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

Explain a differential backup?

0 Answers  

---

What is coalesce and check constraint in sql server?

0 Answers  

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

What is query optimizer in sql server?

0 Answers  

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

---

what are the problems in logshipping?

3 Answers  

---

How to make remote connection in database?

0 Answers  

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---