No announcements
Found 2772276 threads
-
1 VotesCapture of "return" value from stored procedures
Hello rpi, you can change the return statements for select statements and then you can call the stored procedure and cast the value returned to an Int32. Hope this ...Answered | 1 Replies | 3247 Views | Created by r31416 - Sunday, May 8, 2011 9:16 PM | Last reply by Miguel Fernández Corral - Monday, May 9, 2011 12:12 AM
-
0 Votes
Entity Framework 5, Stored Procedure
on some condition result set has different columns) Entity framework doesn't support stored procedures returning multiple result sets - ...Answered | 4 Replies | 64 Views | Created by Anonymous - Monday, March 24, 2014 1:36 PM | Last reply by Anonymous - Tuesday, March 25, 2014 6:39 AM -
0 Votes
Handling multiple result sets from a sp
promoted ad my sp returns 2 sets of results. First one says (0 row(s) affected) and the second one says for example (4 row(s) affected). I would like to drop the first result set ...Answered | 6 Replies | 4461 Views | Created by msoyturk - Wednesday, June 8, 2011 9:19 AM | Last reply by msoyturk - Thursday, June 9, 2011 7:05 AM -
0 Votes
Stored Procedures - Return single record
Anyone know how to return a single record from a stored procedure using linq to sql? I know you can return a resultset using something ...Answered | 1 Replies | 3964 Views | Created by acoldone - Wednesday, May 20, 2009 11:06 PM | Last reply by acoldone - Wednesday, May 20, 2009 11:16 PM -
0 Votes
Combing multiple result sets from SELECT
from #Result However, there is also a possibility you can get desired result with just one select ...Answered | 4 Replies | 4351 Views | Created by Igor_Proper - Wednesday, November 10, 2010 10:05 PM | Last reply by Igor_Proper - Thursday, November 11, 2010 9:47 PM -
0 Votes
Getting one result from multiple store procedures
You can use multiple stored procedures. But it looks like you should convert the query from the 2 SPs into views or table-valued functions. You can then reuse them ...Answered | 4 Replies | 5594 Views | Created by Vil H - Tuesday, May 22, 2007 4:12 PM | Last reply by Umachandar Jayachandran - MS - Tuesday, May 22, 2007 6:57 PM -
0 Votes
mapping stored proc result sets from datatables to classes
End Set End Property End Class ...and if I have a stored proc that returns ...Answered | 1 Replies | 3 Views | Created by Anonymous - Thursday, December 16, 2010 2:24 PM | Last reply by Anonymous - Thursday, December 16, 2010 10:22 PM -
0 Votes
Datareader with multiple result sets
/max pool size was reached" errors. Our concern is if the above approach of getting multiple result sets and passing sqldatareader to each function can cause ...Answered | 3 Replies | 27 Views | Created by Anonymous - Monday, July 13, 2015 6:27 PM | Last reply by Anonymous - Saturday, July 25, 2015 4:19 AM -
0 Votes
Multiple Active result sets
Hello there, Is there any handicaps using MultipleActiveResultSets option in a connection string if needed to work with nested datareader operations? Why ...Answered | 1 Replies | 2856 Views | Created by Burak SARICA - Thursday, March 1, 2007 6:34 PM | Last reply by Geert Verhoeven - Friday, March 2, 2007 6:44 AM -
0 Votes
Linq and stored procs with multiple result sets
User1085970526 posted I tried to use linq to sql to get data from my stored procedures, but it only returns the first recordset. Is there any way to ...Answered | 2 Replies | 1 Views | Created by Anonymous - Monday, January 14, 2008 12:26 PM | Last reply by Anonymous - Friday, January 18, 2008 5:45 PM -
0 Votes
execute multiple stored procedures simultaneously
Hi, I am thinking of executing multiple stored prcedures simltaneously instead of sequentially to save data retreiving time. In my case, simultaneous execution ...Answered | 4 Replies | 8981 Views | Created by sirkal - Thursday, December 10, 2009 4:17 PM | Last reply by sirkal - Thursday, December 10, 2009 8:32 PM -
0 Votes
Show return value from stored procedures
statements to retrieve values from it. iv) In StoredProcedure call in SSRS, you need to call a custom code to generate this entire query on runtime based on selected ...Answered | 8 Replies | 4148 Views | Created by ashubhatt - Friday, June 20, 2008 9:07 AM | Last reply by Kumar82 - Wednesday, June 23, 2010 3:52 PM -
0 Votes
retrieving return values from stored procedures
return value of your stored procedure from the typed dataset, you can follow this way described in ...Answered | 12 Replies | 3 Views | Created by Anonymous - Wednesday, August 19, 2009 1:11 PM | Last reply by Anonymous - Wednesday, August 26, 2009 11:56 PM -
2 Votes
Load entity sets using only stored procedures
future date, a way fo turn off the EF from automatically going to the database and loading data when a developer only wants to use stored procs, and not accidentally execute selects ...Answered | 5 Replies | 3955 Views | Created by nlm - Monday, May 16, 2011 9:19 PM | Last reply by nlm - Friday, June 3, 2011 3:06 PM -
0 Votes
xsd and stored procedure with multiple result sets
User1716267170 posted Hi d3fcon, If you call the stored procedure directly via ado.net, the multiple results can be easily handled like above. ...Answered | 2 Replies | 13 Views | Created by Anonymous - Saturday, June 12, 2010 11:46 AM | Last reply by Anonymous - Tuesday, June 15, 2010 10:10 PM -
0 Votes
listview stored procedures return value
User-192026228 posted Hi there, In my DataContext I have an Orders table with an stored procedure in update method. The SQL ...Answered | 5 Replies | 5 Views | Created by Anonymous - Monday, January 24, 2011 12:49 PM | Last reply by Anonymous - Tuesday, January 25, 2011 4:55 AM -
0 Votes
Getting return values from stored procedures
containing the PK. However, I can't figure out how to actually get the data from the RETURN statment. I saw some code which referenced ...Answered | 3 Replies | 3 Views | Created by Anonymous - Thursday, February 3, 2011 4:41 PM | Last reply by Anonymous - Thursday, February 3, 2011 8:57 PM -
0 Votes
Stored Procedure returning multiple result sets from other called stored procs
by Proc B, so I only get what Proc A is trying to return. I think it's not possible. if you don;t want to get the other data ...Answered | 1 Replies | 22 Views | Created by Anonymous - Monday, July 21, 2008 3:14 PM | Last reply by Anonymous - Tuesday, July 22, 2008 1:13 AM -
0 Votes
Database tabels design for multiple countries and language
There are few things you need to consider to write a Database that will support data from multiple languageAnswered | 2 Replies | 5 Views | Created by Anonymous - Thursday, March 6, 2014 6:16 AM | Last reply by Anonymous - Monday, March 10, 2014 5:04 AM -
1 Votes
using multiple active result sets
; { //generate error if multiple active result sets are not enabled in the connection ...Answered | 2 Replies | 2679 Views | Created by Sridhar Rajan Venkataramani - Wednesday, September 5, 2012 7:31 AM | Last reply by Sridhar Rajan Venkataramani - Wednesday, September 5, 2012 9:29 AM
No announcements
