Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 15018 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / anand
SRTORED PROCEDURES : STORED PROCEDURES IS A SET OF SQL
STATEMENT WHICH CAN NOT EXECUTES AUTOMATICALLY.
TRIGGERS : TRIGGERS IS A STORED PROCEDURE AND EXECUTES
AUTOMATICALY. IF ANY CHANGES OCCURED IN A TABLE OF DATABASE
I.E. INSERT, UPDATE OR DELETE STATE IS OCCURED IN TABLE IT
FIRED AUTOMATICALY .
| Is This Answer Correct ? | 13 Yes | 6 No |
Post New Answer View All Answers
What types of replication are supported in sql server?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How to write a query with a full outer join in ms sql server?
What are the different types of collation sensitivity?
Is foreign key a primary key?
What is the user of Primary key?
What is the difference between clustered and a non-clustered index?
How self join is different from outer join?
What are “lock” hints?
How to delete exactly duplicate records from a table?
what data regions are and what are the different data regions?
Explain what is scheduled job and how to create it?
How to create prepared statements using odbc_prepare()?
What are the differences between char and nchar in ms sql server?
what is a correlated sub-query? : Sql server database administration
