Difference between Triggers and Stored Procedure
Answer Posted / amar goala
The main differnce is that S.P. is explicitly calling for
execute else Onece a Trigger is created Its fired
automatically when any event
occurred like update,insert,delete on table in run time.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are built in functions?
Explain about link server in sql server?
Explain query editor regions
Why we need to use secondry database file? though, we can do same work using primary database file also.
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Tell about MOM Tool(Microsoft Operator Manager)?
How will you monitor replication latency in transactional replication? : sql server replication
How to find the version of sql server? : sql server database administration
How to create a new table in a given schema?
How to list all dsn entries on your local machine using odbc_data_source()?
Can we call stored procedure in trigger?
What are the advantages dts has over bcp?
What is candidate key with example?
What is a collation?
Can sql servers link to other servers like oracle?