I'm learning Cursor and did some code feeding a cursor variable using select stament like this
declare MyCursor cursor for (select name from Client )
Is it possible to feed cursor but using Exec command. I would like to retrieve some information from a procedure sp_spacedused.
declare MyCursor cursor for exec sys.sp_spaceused client
Is it possible ?