dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: What are the magic tables available in SQL Server 2000?

  1. #1
    Join Date
    Apr 2019
    Location
    Ahmedabad
    Posts
    7

    What are the magic tables available in SQL Server 2000?

    What are the magic tables available in SQL Server 2000?

  2. #2
    Arjay's Avatar
    Arjay is offline Moderator / MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,060

    Re: What are the magic tables available in SQL Server 2000?

    Please define 'magic tables.'

  3. #3

    Re: What are the magic tables available in SQL Server 2000?

    The 'magic tables' are the INSERTED and DELETED tables, as well as the update() and columns_updated() functions, and are used to determine the changes resulting from DML statements.

    For an INSERT statement, the INSERTED table will contain the inserted rows.
    For an UPDATE statement, the INSERTED table will contain the rows after an update, and the DELETED table will contain the rows before an update.
    For a DELETE statement, the DELETED table will contain the rows to be deleted.
    The primary use of these tables are for more complex operations when triggers are fired.

Tags for this Thread

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)