How to assign variable value returned from exec(@sql)

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

ramuvanparti SSCrazy Points: 2368 More actions · Answer 1

use exec sp_executesql for it.

refer books online for the same

t.hitendra SSCommitted Points: 1620 More actions · Answer 2

Hi,

It can be done with sp_executesql with 'output' variable.

enriquedelafuentem Grasshopper Points: 22 More actions · Answer 3

Hi,

How can I do it, if I need to do it from a function?

I tried but I got:

'Only functions and extended stored procedures can be executed from within a function.'

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 4

If you need to use dynamic SQL you're better off using a stored procedure instead of a function:

Will that work with what you're trying to use the function for?

enriquedelafuentem Grasshopper Points: 22 More actions · Answer 5

Yes, it works with stored procedures, but is not "elegant".... anyhow, thanks a lot