Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is the Best approach to put code, among Triggers
and Procedures? Explain?
- 1 Answers
- 5603 Views
- Sierra Atlantica, I also Faced
- E-Mail Answers
Answer Posted / gogu s k
For security and audit related events and to record changes
done to database, triggers are best.
For applying business rules and performing dml operations
procedures are ideal.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why truncate is faster than delete?
Which sql statement is used to delete data from a database?
Is primary key clustered or nonclustered?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Can I create table without primary key?
What is cursor and why it is required?
what are the differences between char and varchar? : Sql dba
What is identity column in sql server?
What are the different types of triggers?
what is difference between delete and truncate commands? : Sql dba
How to revise and re-run the last sql command?
How can check sql version from command line?
What is primary key and unique key?
Can you skip header records while loading? : aql loader
What are views in sql?
