Answer Posted / chandra rekha
Triggers use magic tables(update and delete tables)
| Is This Answer Correct ? | 9 Yes | 35 No |
Post New Answer View All Answers
what is a self join? : Sql server database administration
What are the advantages of having an index on the sql server?
What is set nocount on?
What happens if you insert a duplicate key for the primary key column in ms sql server?
How to use old values to define new values in update statements in ms sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Which tcp/ip port does the sql server run on? How can it be changed?
How to insert data with null values?
What are the steps you can take to avoid “deadlocks”?
how would you store your query in an SSRS report or a Database server?
how you can configure a running aggregate in SSRS?
How do you trace the traffic hitting a sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation