Wht is the difference between stored procedure and trigger
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 not null constraint?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is a constant or literal in ms sql server?
How can you set the threshold at which sql server will generate keysets asynchronously?
Describe in brief authentication modes in sql server.
what is the sql equivaent of the dataset relation object ?
What is a deadlock and what is a live lock?
How does using a separate hard drive for several database objects improves performance right away?
Describe how to use linked server?
Why use sub query in sql server and list out types of sub queries?
How to declare and use cursor variables?
What are different types of raid configurations? : SQL Server Architecture
What is the full meaning of dml?
How to declare a cursor with "declare ... Cursor" in ms sql server?