Answer Posted / pramod bansode

1> For executing Sp we have to call Stored Procedure. But in
case of Trigger it is call whenever there is an action taken
on table or column(Insert, Update ,Delete).
2> From SP we pass Values But from Trigger we cant.
3> stored procedure returns value but trigger cannot returns
value.
4> For SP we have to compile. for Trigger no need to compile.
5> we return SP in Trigger but Trigger can not be in SP.

What is self contained scalar sub query?

1014

---

Do you know clustered and non-clustered index?

1018

---

How to specify the collation for a character data type in ms sql server?

1078

---

Characterize join and name diverse sorts of joins?

1021

---

What is an execution plan? When would you use it?

1024

---

What is nolock hint in sql server 2008

1178

---

how many type of indexing in database?

1019

---

What are the different types of backups that exist?

1216

---

What is cursors? And what are the different types of cursor?

1194

---

Mention a few common trace flags used with sql server?

978

---

What is the default sql server instance name?

1084

---

How to find index size for each index on table?

1051

---

What is a fan-out query in SQL Azure?

123

---

What is triggers in ms sql server?

1179

---

Can you insert NULL in unique column?

1207

---