Answer Posted / shreenath27@yahoo.co.in

function will return value but procedure will not return any
value

What is the default order of an order by clause?

995

---

Why de-normalization required?

1003

---

What is the difference between a primary key and a unique key? Are they the same?

1077

---

What are the differences between sql server and mysql.

1096

---

What is the difference between sdf and mdf?

1300

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

---

Explain about Normalization?

1067

---

Define full outer join in sql server joins?

992

---

Can two tables share the same primary key?

917

---

What is the difference between deallocate cursor and close cursor?

1260

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1093

---

Can primary key be a foreign key?

1058

---

Is t sql the same as sql server?

975

---

what is sql server? : Sql server database administration

987

---

What command must you use to include the not null constraint after a table has already been created?

1146

---