What are the magic tables in SQL Server 2000?
Answer Posted / jerry joseph
NO THERE IS NO UPDATED MAGIC TABLE
only 2 magic tables
- INSERTED
- DELETED
in case of an Update operation the original row is stored in
the DELETED table and the new row is saved in the INSERTED table
Is This Answer Correct ? | 31 Yes | 0 No |
Post New Answer View All Answers
What is the use of builtinadministrators group in sql server? : sql server security
Describe how to use linked server?
Mention the 3 ways to get a count of the number of records in a table.
What is a not null constraint?
What is the difference between mysql and mysqli?
How do I view views in sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Explain Geography datatype in SQL Server
What is a raid and what are different types of raid configurations?
Is a primary key unique?
What are four major operators that can be used to combine conditions on a where clause?
Explain about unique identifier data type in sql server?
What is the difference between primary key and unique constraints?
What is the new security features added in sql server 2014? : sql server security
What are drilldown reports?