INSERT, UPDATE clause inside UDF

[ganeshkumar08]

Hi SQL friends,

My doubt is can we INSERT , UPDATE clauses inside function..
if yes can u give an example function..

Ganesh Kumar

[ck9663]

I think, technically, you can. Here's the full syntax.

What are you trying to do? SP's might be what you need and not a function. SP's can also return values through OUTPUT parameters.

-- CK