What is difference between Triggers and store procedure?
Answer Posted / vidit tyagi
triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is meant by indexing files?
How does using a separate hard drive for several database objects improves performance right away?
What is optimistic concurrency?
How to insert multiple rows with a subquery?
Explain the stored procedure?
Explain transaction isolation levels in sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Why would you call update statistics?
What does Master database contains?
What is database architecture? : SQL Server Architecture
Comment,Datatypes are unlimited
What are the types of ssrs?
Explain activity monitors
When you should use a low fill factor?