Where are magic tables stored ? Is it in the same database
where it is created ?
Answers were Sorted based on User's Feedback
Answer / digvijay kumar singh
magic table is concept of triggers. when trigger perform the
insert,delete and update action on the table. the create a
temprory table that is called the magic table. when perform
dalete action:-- all deleted row stored in to a table
thease table is called "Deleted table" such that insert
action: create "created table" these table called the magic
table.
when trigger commited the magic table automatically deleted.
it is stored in Temp database of sql server.
i hope any person gotted.
Is This Answer Correct ? | 25 Yes | 0 No |
Answer / raja
At the time of creating triggers magic tables will be created.
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / digvijay kumar singh
yes, magic table stored in current databse.
Is This Answer Correct ? | 8 Yes | 2 No |
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How each E-R model constructs can be mapped to the relational model?
How do you create an execution plan?
What do I need to start working with sql studio? : sql server management studio
What are the four main query statements?
Explain how to integrate the ssrs reports in application?
What is the difference between indexing and hashing?
Explain the difference between delete,drop and truncate in SQL Server?
Describe in brief sql server monitoring ways.
What are cursors stored procedures and triggers?
What is implicit cursors?
Explain how dts is used to extract, transform and consolidate data?