adspace


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are Magic Table?

Question Posted / puneet sharma

Answer Posted / puneet sharma

INSERTED and DELETED tables known as MAGIC
TABLES.BECAUSE IN BOTH THE CASES TRIGGER FIRES AND
TEMPORARILLY STORE INSERTED AND DELETED VALUES
RESPECTIVELLY.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql or structured query language?

1235

How do I find query history in sql server?

1034

How do I start sql server 2017?

1024

How can we solve concurrency problems?

1130

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2300

Can we do dml on views?

1042

What is clustered index

1094

Equi join and non equi join is possible with sql server?

1140

What are the properties of the transaction?

1084

How to enter binary string literals in ms sql server?

1256

What is in place upgrade in sql server?

1137

How to convert character strings into numeric values?

1196

Where can you add custom error messages to sql server?

1220

How to connect php with different port numbers?

1197

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8239