Answer Posted / mohit johri

Kindly ignore the last statement in my posted answer which
says 'Exec(@sql)' it was wrongly copied

What is a join in sql? What are the types of joins?

1036

---

What are trace flags and mention a few common trace flags used with sql server?

1052

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

909

---

What are the restrictions that views have to follow?

928

---

what are constraints? : Sql server database administration

1004

---

What is the significance of null value and why should we avoid permitting null values?

941

---

What is the default value of an integer data type in sql server 2005?

918

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2292

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2017

---

What is hot add cpu in sql server 2008?

896

---

what's the difference between a primary key and a unique key? : Sql server database administration

908

---

Mention the different types of replication in sql server.

976

---

How to enter date and time literals in ms sql server?

966

---

What protocol does sql server use?

900

---

What is the difference between resultset and resultsetmetadata?

907

---