Post reply

To Create a function

  • August 23, 2008 at 4:27 am

    #382393

    Hi,

    I want to know that is it possible to create a function by using

    insert,update,delete command?

    Regards,

    Sunil.....

  • August 23, 2008 at 5:01 am

    #862216

    Functions aren't allowed to have side-effects, i.e. they aren't allowed to change the state of the database in any way.

    It's so that when they are included in querues, it doesn't matter whether the optimiser chooses a plan that runs a function once, or several times.

    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

  • August 24, 2008 at 11:50 am

    #862310

    I want to know that is it possible to create a function by using

    insert,update,delete command?

    No.

    _____________________________________
    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.

  • August 24, 2008 at 10:01 pm

    #862358

    Thanks for reply...........

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

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