Answer / Dibya Prakash Tiwari

A table can have only one primary key.

What is the xml datatype?

1 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

Can you please explain the difference between function and stored procedure?

1 Answers  

---

Do you know hot add cpu in sql server 2008?

1 Answers  

---

How to use old values to define new values in update statements in ms sql server?

1 Answers  

---

How to modify existing triggers using "alter trigger"?

1 Answers  

---

How to find out the list schema name and table name for the database?

1 Answers  

---

Why do we use trigger?

1 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

Explain the stored procedure?

1 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1 Answers  

---

What is set nocount on and what is set nocount off?

1 Answers  

---