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...

Answer / kailash dhondiyal

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.

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.

Answer / sandeep

Tables used in triggers like inserted,deleted,updated are
called magic tables.

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.

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.

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.

Define data adapter?

0 Answers  

Which is the best institute in hyderabad to learn DotNet?

11 Answers   Cognizant,

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

0 Answers  

What are the different methods by which we can populate a dataset?

0 Answers  

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

How can we check that some changes have been made to dataset since it was loaded?

0 Answers  

what is type dataset?

3 Answers  

What providers does Ado.net uses?

0 Answers  

What are the classes in System.Data.Common Namespace?

0 Answers  

Explain how to find the given query is optimised one or not?

0 Answers  

What is ado.net explain with diagram?

0 Answers  

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,