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.

Why are you getting errors when creating a new odbc dsn?

0 Answers  

---

What is page in sql server?

0 Answers  

---

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

---

Explain the properties of sub-query in sql server?

0 Answers  

---

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

Where are stored procedures in sql server?

0 Answers  

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

Explain syntax for disabling triggers?

0 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

Explain syntax for dropping triggers?

0 Answers  

---

why SQL server is more used to store database rather than Access

2 Answers  

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---