• GilaMonster (4/10/2012)


    Gianluca Sartori (4/10/2012)


    CLR tricks aside, how can you call a procedure inside a function?

    OPENROWSET

    Doesn't make it good practise, can have some really fun effects (functions aren't allowed to change data so that the optimiser is free to run it as many times as it likes)

    HA! That's a good one.

    I even have a blog post on that trick and I didn't think of it!

    Thanks

    -- Gianluca Sartori