Answer Posted / avdhesh yadav

1. Stored Procedure may Return a value but Trigger Not,
2. In Stored Procedure you can pass parameter But in
trigger you can't
3. we explicitly call the Stored Procedure when Trigger are
implicitly
fired
4. you can write a Stored Procedure in Trigger but in a
Trigger you cant
write Stored Procedure.
5. Trigger written on an individual Table or View where
Stored Procedure
is written for an Database

Is it true, that there is no difference between a rule and a check constraint?

1038

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

976

---

What is a bit datatype?

981

---

what data regions are and what are the different data regions?

141

---

How to check status of stored procedure in sql server?

975

---

What is function of ROLLUP ?

1078

---

How to generate create table script on an existing table in ms sql server?

1141

---

How does recursive cte works in sql server?

1005

---

What are different types of raid configurations? : SQL Server Architecture

1066

---

Tell about MOM Tool(Microsoft Operator Manager)?

1906

---

How to scale out a federation by Sql statement?

116

---

what exactly sql injuction.how to overcome.....

2534

---

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

1023

---

What is difference between standardization and normalization?

1087

---

How to connect to SQL Azure Database by using sqlcmd?

136

---