• Here u can improve performance more by specifying column names rather than using "*". Because using * queries sys.columns system table for get the column names, which is unnecessary when we can simply specify them.

    But you have to remember to update SP when u change the table(columns).

    regards,

    http://onlinecoder.blogspot.com/