Post reply

How to get data

  • June 5, 2008 at 1:25 am

    #121882

    Hi,

    I have to get data which is not committed and deleted data also require. So can any one tell that how could i get the data ?

    Regards,

    Sunil

  • June 5, 2008 at 1:52 am

    #824668

    For deleted data you can use trigger on DELETE!

    so for the uncommitted data you can use

    BEGIN TRANSACTION

    T-SQL code here ...testing here and finally if you want to do the changes you can use

    COMMIT TRANSACTION

    if you don't want to do the changes use

    ROLLBACK TRANSACTION

    Hope it helps to understand for more detail looks at Books online about Trigger and (BEGIN TRAN...COMMIT TRAN OR ROLLBACK TRAN)

    or give us the table definition and somebody helps you about your problem !

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • June 5, 2008 at 2:12 am

    #824672

    If you want to see uncommitted data, change the transaction isolation level:

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    (your statements here)

    See BOL for more information about this item

    Wilfred
    The best things in life are the simple things

Viewing 3 posts - 1 through 2 (of 2 total)

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