Answer / deepak baldia

A stored procedure is a set of SQL commands that has been
compiled and stored on the database server.

A trigger is a special kind of stored procedure that is
invoked whenever an attempt is made to modify the data in
the table it protects. Modifications to the table are made
using INSERT,UPDATE,OR DELETE statements.

Answer / michael jerold

sp means to execute set of quries in single sp.and we can
call manually.


Trigger means dml operation happens the event will fire
automatically. we can not call manually.

Answer / vim@l katiyar

stored procedure is collection of sql query/command.it is database object.it stored in databse and uses for validation data and data access from data source. but it has some disadvantage like this .if more than one SP uses same server .
server performance down and once create and use many times.

trigger is sql procedure that initiates action when database modification query perform.it is automatically create .it is not executed like stored procedure .it is also execute stored procedure . when data modification sql command executed then action performed by trigger

How does asp page work?

0 Answers  

---

What is the difference between login controls and forms authentication?

0 Answers  

---

Which template must you provide, in order to display data in a Repeater control?

3 Answers  

---

What is session and application variable in asp net?

0 Answers  

---

What is localization and Globalization?

3 Answers  

---

what are the types of ASP objects ?

7 Answers   Satyam,

---

Have you used microsoft dataaccess blocks and Exception blocks?

1 Answers   Microsoft,

---

What is the namespace to create thread in .net?

0 Answers  

---

What is difference between or and orelse?

0 Answers  

---

what are debugging types in .net?

2 Answers   ABC, NIIT,

---

how we deploy the asp.net 2.0 application

2 Answers   Logistics,

---

Webconfig file is cofiguration of server or browser?

10 Answers   Wipro,

---