Results 1 to 2 of 2

Thread: SQL statement

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jun 2000
    Posts
    156

    SQL statement

    Hi there,
    I was wondering how I can get the SQL statement that made a trigger fire.
    For example: insert into customers values(1, 'joe') fires get_customer() and
    that function has a variable with the value "insert into customers values(1,
    'joe') ". How can I do this?

    Thanks in advance,

    LirLir
    The MORE I get to know,
    I realize that I know NOTHING !

  2. #2
    Fanatic Member simonm's Avatar
    Join Date
    Sep 2000
    Location
    Devon, England
    Posts
    796

    Smile Trace

    Use the SQL Profiler to do a trace and every SQL statement is logged in there.
    Everything I say is either loose interpretation of dubious facts or idle speculation rooted in irrational sentiment.

Posting Permissions

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



Click Here to Expand Forum to Full Width