SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:10 PM
| ||||
| ||||
 assign EXEC() to a variable ? Is it possible to capture the output of a EXEC() statement into a variable ? I construct a dynamic sql which returns a single value (SELECT count(*) from X) and I execute this sql using EXEC. So is there anyway I can assign the count (*) value to a local variable ? Or any other suggestions for this issue ? Thanks for your time."      |
|
02-27-2008, 07:10 PM
| ||||
| ||||
| Re: assign EXEC() to a variable ? See if this helps: http://support.microsoft.com/default...b;en-us;262499 -- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ What hardware is your SQL Server running on? http://vyaskn.tripod.com/poll.htm "exBK" <chikkodi@yahoo.com> wrote in message news:0b5101c33f4d$c09f1a70$a001280a@phx.gbl... Is it possible to capture the output of a EXEC() statement into a variable ? I construct a dynamic sql which returns a single value (SELECT count(*) from X) and I execute this sql using EXEC. So is there anyway I can assign the count (*) value to a local variable ? Or any other suggestions for this issue ? Thanks for your time." |
Linear Mode
