Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the equivalent of date() and time() in asp.net?
Describe the Server Control Events of ASP.NET?
What are the different session state management options available in asp.net?
List of words of preprocessor in .net?
how can we create wcf in asp.net and how can we cll that in to asp.net application?plsss tel me each step clearly
Are there resources online with tips on asp to asp.net conversions?
How to send a DataReader as a parameter to a remote client ?
Explain how viewstate is being formed?
What tags do you need to add within the asp:datagrid tags to bind columns manually? Give an example.
What are type/key pairs in client script registration?
What does a switch do?
What is difference between cookies and cache?
What is application in asp net?
What is a 1x1 pixel?
How do cookies work? Give an example of their abuse.
