Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: what are magic tables?

    Can any one tell me what are magic tables in sql server?

  2. #2
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: what are magic tables?

    are you talking about temporarary tables like
    #Table and ##Table ???

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    hmm ... magic tables ... they are what are the center of Brett's so called miracles
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    i think you are refering to the inserted and deleted tables when a trigger is fired.

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    or table variables .. coz they exist only in memory ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I seem to have misplaced my copy of "David Blaine's Guide To SQL".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by blindman
    I seem to have misplaced my copy of "David Blaine's Guide To SQL".
    Miracle indeed....

    http://www.davidblaine.com/

    Do the tables automatically back themselves up and prevent user error?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •