Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is the difference between stored procedure and trigger
- 6 Answers
- 14841 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 difference between drop truncate and delete?
What is amo? : sql server analysis services, ssas
How to insert a new row into a table with "insert into" statements in ms sql server?
How to specify the collation for a character data type in ms sql server?
What does the on delete cascade option do?
Explain the use of containers in ssis and also their types?
How many types of objects are there?
What is table valued function and scalar valued functions?
Explain what is log shipping?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Is sql different from sql server?
How important do you consider cursors or while loops for a transactional database?
Explain about SQL server 2005?
What are the approximate numeric data types?
What is the use of partition by in sql server?
