Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrent between store procedure and trigger
- 2 Answers
- 5158 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
1)Actually Trigger is an action which is performed
automatically after or before an event occure. But Store
procedure is executed when it is call.
2)We can call Trigger inside the store procedure. But
reverse is not possible.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How does index makes search faster?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain how to integrate the ssrs reports in application?
What is updatable resultset?
Name and describe few console utilities for ssrs?
How to filter out duplications in the returning rows in ms sql server?
Difference between DELETE and TRUNCATE?
Explain filtered indexes benefits?
what is the system function to get current user's user id? : Sql server database administration
What is the meaning of sql server?
Explain what are magic tables in sql server?
What are synonyms?
How to how to convert numeric expression data types using the convert() function??
Is the primary key column of a table an index in ms sql server?
What is the report model project?
