Magic Table

Question

Post reply

Magic Table

Kayal

Right there with Babe

Points: 750
More actions
September 14, 2005 at 3:22 am

#89036

Does anyone know what 'Magic Table' means, I was asked this recently in an interview......

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246959 More actions · Answer 1

Not in SQL Server - but perhaps it's something to do with Magic Software ???, check out:

http://www.magicsoftware.com

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Lowell SSC Guru Points: 323518 More actions · Answer 2

The magic tables are the virtual tables available in a trigger:

ie the [INSERTED] and [DELETED] tables, which can be referenced within a trigger so that you can add additional logic based on the values of the rows being inserted or deleted.

Microsoft does not call them magic tables, by the way. dunno where the name started from. pretty crappy question to ask a candidate, if you ask me.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

sushila SSC-Dedicated Points: 35293 More actions · Answer 3

CM - I'm curious - are you by any chance from India ?! For some weird reason (unless it's coincidence) I've come across 2 posts referring to these "magic tables" and both post(ers) are from India...

magic 1

magic 2

**ASCII stupid question, get a stupid ANSI !!!**

Kayal Right there with Babe Points: 750 More actions · Answer 4

Thanks a lot guys !!!!!

Well, I too thought it was such a wierd thing to ask......... when in fact there are a lot of mind cracking questions to be asked in SQL Server....

homebrew01 SSC Guru Points: 55548 More actions · Answer 5

homebrew01

SSC Guru

Points: 55548

September 15, 2005 at 9:38 am

#590197

I could use a dose of magic from time to time !

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 6

I only use the 'magic tables' in my 'PFM' database ...

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

DCPeterson SSCoach Points: 15266 More actions · Answer 7

OK, I'll bite... PFM???

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

*****************/

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 8

PFM = 'pure f**king magic'

analogous to the FM box

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."