What is the Magic Tables in Sqlserver2000?
Answers were Sorted based on User's Feedback
Answer / kalirajan
When u r creating the table at the same time two
tables(Insert table, Delete Table) r created automatically
at the backend. It is Magic Table k...Moreover we can't
able view that table...
Is This Answer Correct ? | 9 Yes | 0 No |
When a trigger is fired for any DML command. Then 2 tables
automatically create on backend. One table is for Insert
and other one is for Delete. These tables are called Magic
Tables.
Number of records in both tables should be same.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ahmed kapasi
magic tables are used to get the values which are updated
from a DML statement in a trigger. for example if an update
statement is fired that time the new value goes to the
inserted table and old value goes to the deleted table, you
can fetch this values from this two tables if required.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sandeep
Tables used in triggers like inserted,deleted,updated are
called magic tables.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vishal rastogi
Magic Table is basically a sort of Virtual table in SQL
Server,whenever we insert or delete data from a table then
that data is stored in a table called as Magical Table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kavita
When we are trying to create a new table,and when its get created with that, two tables get create automatically,and that are insert and delete table ,and we cant view that,bt whenever we do any transaction with that created table by us,automatically that both magical tables also get affected.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashish sharma
create table uname
(
id int,
uname varchar(10)
)
create trigger insert_Uname
on uname
for insert
as
declare @nm varchar(10)
select @nm = uname from inserted
print @nm
so when we insert any record in the above table
the username will be get printed.
Is This Answer Correct ? | 0 Yes | 1 No |
what is trigger?
8 Answers Microsoft, Precept Technology,
How do you connect to sql server database without using sqlclient?
What are all the commands used with Data Adapter?
What are all the different authentication techniques used to connect to MS SQL Server?
Does dapper use ado.net?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What are dcl commands?
What are the data providers in ADO.NET framework?
Can you edit data in the Repeater control?
How to fetch the last inserted record in a particular table?
10 Answers CarrizalSoft Technologies, Microsoft,
suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validation contrl for dd/mm/yy formator how we assign regular expression for same
Which method do you invoke on the DataAdapter control to load your generated dataset with data?