explain store procedure and trigger

Answer Posted / 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.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain cookies with example.

746


Differentiate between file-based dependency and key-based dependency.

714


What is a uri query?

747


Differentiate between a page theme and a global theme?

709


What is different in .net 1.1 and .net 2.0?

759


What are session state modes? List some of the important session state modes of asp.net.

714


How can we call webservices in Banking Applications? and where we are using it?

1728


How do you declare static variable?

750


How could you modify xaml content from javascript?

714


List the events in page life cycle.

720


What is the full meaning of asp.net?

702


What are the different web pages?

658


What is data grid view in asp.net?

696


Define repository pattern in mvc.net? : asp.net mvc

735


What’s difference between “optimistic” and “pessimistic” locking?

782