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

what is a mixed extent? : Sql server administration

782

---

Explain what is the function of sql server agent windows service?

744

---

How to query multiple tables jointly?

744

---

How do indexes help, types?

751

---

How much is a sql server license?

728

---

Can you edit the .rdl code associated with a linked report?

121

---

What is PROJECTION Operation?

785

---

Describe in brief sql server monitoring ways.

780

---

How to drop an existing table?

766

---

How to generate random numbers with the rand() function in ms sql server?

789

---

Describe how to use the linked server?

838

---

How to view existing indexes on an given table using sp_help?

832

---

What are the different editions available in sql server 2000?

794

---

Name 3 ways to get an accurate count of the number of records in a table?

787

---

What are sql server procedures?

766

---