Difference between Triggers and Stored Procedure
Answer Posted / pankaj arya
To use stored procedure you have to make a call to that
procedure but Triggers fired automatically when an event is
occurred on the table associated with that Trigger like add,
insert or delete.
| Is This Answer Correct ? | 108 Yes | 7 No |
Post New Answer View All Answers
What is merge?
What is tempdb database? : SQL Server Architecture
What is the difference between dropping a database and taking a database offline?
Define Unique Key?
What are the differences between clustered and non-clustered index?
What are the advantages of user-defined functions over stored procedures in sql server?
Define self join?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Explain the architecture of ms sql reporting service?
What is the usage of sign function?
What is dbcc? Give few examples.
What is row_number function?
How to retrieve field values using mssql_result()?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)