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.

How to display a past time in days, hours and minutes?

0 Answers  

---

How to receive returning result from a query?

0 Answers  

---

How to write a query with a left outer join in ms sql server?

0 Answers  

---

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

---

What are SSL and TSL protocols?

0 Answers   Wipro,

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

---