Post reply

facts abt sps,views and functions

  • January 19, 2013 at 8:51 am

    #268838

    I just want to know whether or not function can call system or userdefined

    sps?

    Similarly can userdefined sps can call udf in its logic?

    can view call system sps or functions in its definition?

  • January 19, 2013 at 9:17 am

    #1578964

    sej2008 (1/19/2013)

    I just want to know whether or not function can call system or userdefined

    sps?

    Similarly can userdefined sps can call udf in its logic?

    can view call system sps or functions in its definition?

    Yes, Yes and Yes.

    Having said that, there is a limit for sp nesting, on the top of my head that limit is 32 - please somebody correct me if I'm wrong.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • January 19, 2013 at 9:55 am

    #1578971

    A function cannot call a stored procedure

    A stored procedure can call a function

    A view can call a function, not a stored procedure.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 19, 2013 at 11:34 pm

    #1579011

    Thank you

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

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