.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What are magic tables?

Posted By :shah268     Posted Date :November 26, 2009    Points :10   Category :Sql Server 
Sometimes we need to know about the data which is being inserted/deleted by triggers in database. With the insertion and deletion of data, tables named "INSERTED" and "DELETED" gets created in SQL Server which contains modified/deleted data.
Here "INSERTED" and "DELETED" tables are called magic tables.

You can also find related Interview Question to What are magic tables?  below: 

What is the Magic Tables in Sqlserver2000?

In Database for any table or view 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. (More...)

How many types of tables are present in SQL SERVER?

There are 2 types of temporary tables, local and global in sql server.

Local temporary tables are created using a single pound (#) sign and are visible to a single connection and automatically dropped when that connection ends.

Global temporary tables are created using a double pound (##) sign and are visible across multiple connections and users and are automatically dropped when all SQL sessions stop referencing the global temporary table. (More...)

Is it possible to have tables in the dataset that are not bound to any data source?

Yes, I can create table object in code and add it to the dataset. (More...)

What are Fact tables and Dimension Tables?

A fact table typically has two types of columns: those that
contain facts and those that are foreign keys to dimension
tables. facts may be composed of measures,degenerated
dimensions.The primary key of a fact table is usually a
composite key that is made up of all of its foreign keys

Dimension tables, also known as look up or reference tables,
contain the relatively static data in the warehouse.
Dimension tables store the information you normally use to
contain queries. Dimension tables are usually textual and
descriptive and you can use them as the row headers of the
result set. Examples are customers or products (More...)

Get data from 2 tables using join?

Select s.name,s.code,m.eng,m.math from Student S INNER Join Marks m on s.RollNo=m.RollNo; (More...)

What are the ways you can display all the tables in Sql Server?

Way 1:

SELECT Table_Name
FROM information_schema.Tables

Way 2:

FROM SysObjects
WHERE Xtype = 'U' (More...)

How to find total number of tables in a database?


SELECT COUNT(*) AS [table count]
FROM [sys].[tables]

We can get the total number of tables using this query. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend