Comments by noobville

noobville 16-Aug-13 16:25pm View

http://stackoverflow.com/questions/1087200/calling-stored-procedure-via-query-and-getting-return-value-in-c-sharp-without-o
found the above link, there seems to be some way to perform a "exec" via code that can alter a sp...not following the example though

noobville 16-Aug-13 16:24pm View

because FOR XML AUTO formats the data exactly the way I need it.

noobville 16-Aug-13 16:17pm View

No, the integer is useless in relation to the data I need. The sp is being used by an old application, but the owners and my boss want to continue using them.

noobville 16-Aug-13 16:15pm View

Is it possible to send this to the SqlCommand object?
"EXEC [dbo].[sp_GetSomeData] @SomeDataID FOR XML AUTO"
The sp is missing the "FOR XML AUTO", otherwise I cannot use the ExecuteXmlReader to give a XmlReader.

noobville 16-Aug-13 16:13pm View

The returned data is a integer, but when I run the sp in SQL Server studio I can see the result.

Comments by noobville (Top 5 by date)