For the sake of leaning and exploring, I'd like to look at how some of the system functions are built. Is there a way to do this in sql server 2008 or R2?
I've tried sp_helptext 'Sum' but I get an error saying that the resource cannot be found.
I don't think
As a proof - you can e.g. get the body of other system stored functions using
That works just fine - so that leads me to believe that