Post reply

Cursor details

  • May 27, 2008 at 8:51 am

    #191507

    How we can see what cursor is doing as we can see for stored procedure by using "sp_helptext"

  • May 27, 2008 at 9:41 am

    #820629

    DBCC INPUTBUFFER

  • May 27, 2008 at 11:58 pm

    #820985

    If you want to know howmany rows are processed by your cursor, query @@CURSOR_ROWS after you've opened the cursor. See the documentation for some pitfalls if you use this variable.

    Wilfred
    The best things in life are the simple things

  • May 28, 2008 at 4:21 am

    #821065

    Guys , i want to know the text of the cursor not number of rows affected ...

  • May 28, 2008 at 5:43 am

    #821102

    :hehe: I assume, you can't dig into the SQL code to see the cursordefinition ?

    In that case, watch the process with profiler.

    Otherwise, scan you code for phrases like

    declare {name} cursor for

    select {columnnames}

    from {tablename}

    where {whereclause}

    Wilfred
    The best things in life are the simple things

Viewing 5 posts - 1 through 5 (of 5 total)

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