What are Magic Table?

Answer Posted / sushanta kumar sahoo

magic tables are nothing but inserted and deleted in which
the temporary object created by the server internally to
hold the recently inserted values.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know sql server 2008 introduces automatic auditing?

522


Do you know what are the reporting services components?

539


Why truncate is ddl command?

520


What is the current pricing model of SQL Azure?

90


What are the restrictions that views have to follow?

565






Explain tablesample?

557


What do you mean by stored techniques? How would we use it?

593


What do you understand by SQL*Net?

621


Explain about service Broker functions?

621


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3380


What type of Index will get created after executing the above statement?

649


How to use values from other tables in update statements in ms sql server?

565


Explain isolation levels that sql server supports?

577


What are the ways available in sql server to execute sql statements?

578


Difference between group by clause and having clause in SQL?

572