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 |
How to join two tables in a single query in ms sql server?
How to create a simple user defined function in ms sql server?
Do you know the policy based administration feature of sql server 2008?
how do we find every fifth record in a table
What is live lock and deadlock? what is Lock escalation?
What is difference between materialized view and view?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is the difference between a check constraint and a rule?
How to list all user names in a database?
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
How can you insert values in multiple rows using one Insert statement?
0 Answers Flextronics, Thomson Reuters, Virtusa,
how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100