Dynamic SQL - SET STATISTICS TIME - Multiple results

  • ColdCoffee....I too observed the result. Yes...You are correct! Second one will display 2 more result.

    karthik

  • i dont know about the sequence but few other operations are also got performed here like

    @sql variable assignment.

    excecution of dynamic sql , displaying results , different type of locks

    i watched it on profiler( see attachment) and found some extra events in case of dynamic sql though i am not aware of them but it concluded that there are some hidden events occured in case of dymanic sql

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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