Answer / Brijesh Singh

"To copy data from one table to another in SQL Server, you can use the INSERT INTO SELECT statement. For example: INSERT INTO target_table SELECT * FROM source_table."

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1 Answers  

---

What are difference between Cluster index and Non-Cluster index?

1 Answers   QuestPond,

---

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

How can we check the sql server version?

1 Answers  

---

Explain indexing and what are the advantages of it?

1 Answers  

---

Explain syntax for dropping triggers?

1 Answers  

---

Are semicolons required at the end of sql statements in sql server 2005?

1 Answers  

---

Explain about remote stored procedure?

1 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What is the difference between indexing and hashing?

1 Answers  

---

What is difference between sql and sql server?

1 Answers  

---