Post reply

Views vs Table-Valued function - Performance issues

  • May 5, 2010 at 10:40 am

    #1162628

    guys,

    why i cant use EXEC in table value function!!!!!

    any suggestions

    thanks in advance

  • May 5, 2010 at 12:23 pm

    #1162683

    Tamim (5/5/2010)

    guys,

    why i cant use EXEC in table value function!!!!!

    any suggestions

    thanks in advance

    Table valued functions can not cause side effects. Using dynamic sql inside a function could violate that rule, therefore aren't allowed, even if you know for sure that the dynamic sql is read only.

  • May 6, 2010 at 1:10 am

    #1162981

    thxx lunn

Viewing 3 posts - 16 through 17 (of 17 total)

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