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

How would ASP and ASP.NET applications run at the same time on the same server?

1942


What is difference between asp state management and asp.net state management?

570


What is asp net application object?

535


Explain Optimization technique description?

596


Explain global assembly cache.

567






I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.

1424


What is a web api? Which protocol is used in a web api?

543


How do you declare static variable?

559


What is application and session in asp.net?

534


Define asp.net caching?

532


How many types of sessions are there in asp net?

524


What is the difference between union and join?

563


Is LINQ performance wise better or using sqlcommand?

4331


What is the maximum timeout we can set for Cookies?

549


What is web configuration file and how to use in web application

593