Answer Posted / pradeep
Triggers in DB are analogus to the triggers in hand
grenades.
It are reffered a stored procedure call that initiates its
action on any event occures such as insert, update or
delete query.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is reference section?
Explain error handling in ssis?
How to create a store procedure with encryption?
Explain triggers in sql?
What are different types of subquery?
Describe the functionalities that views support.
What are a scheduled jobs or what is a scheduled tasks?
Explain how many types of relationship?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Write a SQL queries on Self Join and Inner Join.
Explain the difference between delete,drop and truncate in SQL Server?
Why de-normalization required?
What are the results of running this script?
What is the difference between inner join and equi join?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
