Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 14602 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 is sql collation?
What are the basic functions for master, msdb, model, tempdb databases?
How to return the date part only from a sql server datetime datatype?
What do you understand by recursive stored procedures?
where can you add custom error messages to sql server? : Sql server administration
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is normalization? Explain different forms of normalization?
How to recompile stored procedure at run time?
what are the types of indexes? : Sql server database administration
What is row-level compre?
How to loop through returning rows?
How to get nth highest salary from employee table.
What is the log shipping?
what are acid properties? : Sql server database administration
Explain can SSRS reports Cache results?
