Post reply

SQL Query Details

  • May 26, 2009 at 12:40 am

    #200796

    I have lots of big queries, on the basis of those queries i have to create a report, as what changes those queries are doing. Is there any way, method, script, function etc. by the use of which it is possible.

    For example: if the query is

    Update SET = , =

    Here the required output is

    Table Name

    Columns to be updated

    Value

    Is there any help!!

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • May 27, 2009 at 12:18 am

    #1000351

    krayknot (5/26/2009)

    I have lots of big queries, on the basis of those queries i have to create a report, as what changes those queries are doing. Is there any way, method, script, function etc. by the use of which it is possible.

    For example: if the query is

    Update SET = , =

    Here the required output is

    Table Name

    Columns to be updated

    Value

    Is there any help!!

    Any help

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • May 28, 2009 at 9:34 am

    #1001513

    Could be execution plans?

  • May 28, 2009 at 9:41 am

    #1001519

    As far as I know by default this data is not sorted.

    You may need to implement some sort of Auditing in your db

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

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

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