Interested to Buy Any Domain ? << Click Here >> for more details...
What are the magic tables in SQL Server 2000?
- 7 Answers
- 25495 Views
- Infogain, Merrill Lynch, I also Faced
- E-Mail Answers
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 subquery? Explain the properties of a subquery?
Explain primary key?
Give a example to search fr a string in all stored procedure in sql server.
Can coalesce return null?
New concepts of sql server 2005 use in your project.
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are different types of raid levels?
What is precedence constraint?
Can you please explain the difference between function and stored procedure?
What is sql collation?
What are truncate options available in sql server? : sql server database administration
what is the sql equivaent of the dataset relation object ?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
what's the information that can be stored inside a bit column? : Sql server database administration
Explain different types of index?
