Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Triggers and store procedure?
- 2 Answers
- 5450 Views
- I also Faced
- E-Mail Answers
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 is nested transaction?
What is the order in which the sql query is executed?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are the system database in sql server 2008?
what is a check constraint?
Do comments need to go in a special place in sql server 2005?
What is acid db?
What method is used by the Command classes to execute SQL statements that return single values?
Explain the ways to controlling cursor behavior?
Explain Geography datatype in SQL Server
What are the types of user defined functions in sql server?
How you would rewrite the sql query to return the customerid sorted numerically?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How do I clean up sql server transaction log?
