What is difference between Triggers and store procedure?
Answer Posted / vidit tyagi
triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the types of dml?
What is similarity and difference between truncate and delete in sql?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is a synonym for manipulation?
How do you make a trace?
What is the usage of sign function?
Explain the difference between primary keys and foreign keys?
What does select 1 mean?
What is a select query statement in ms sql server?
Explain about thread and memory management process of SQL?
Mention what are the core components of ssrs?
Is there any difference between the primary key and unique key?
How to convert a table data in XML format in sql server?
What is nolock hint in sql server 2008
What is normalization process?