No announcements
Found 3484814 threads
-
0 VotesStored Procedure performance using EF4 or L2S or ADO.Net
If you have any feedback, please tell us.Answered | 1 Replies | 4794 Views | Created by Burton H Roberts - Tuesday, November 2, 2010 2:52 PM | Last reply by Alex Liang - Thursday, November 4, 2010 2:45 AM
-
0 Votes
Execute Stored Procedure in ADO.NET Source
Hi DDT12, If you cannot alter the stored procedure, you need to use script task to execute the stored procedure, please refer ...Answered | 6 Replies | 9362 Views | Created by DDT12 - Thursday, February 7, 2013 8:48 PM | Last reply by DDT12 - Wednesday, February 27, 2013 5:54 PM -
0 Votes
ado.net how to pass parameter using stored procedure
Answered | 2 Replies | 1561 Views | Created by anil bhadke - Wednesday, March 9, 2016 7:24 PM | Last reply by Dave Patrick - Thursday, March 10, 2016 4:20 PM -
0 Votes
ADO.NET transaction flow to stored procedures?
Hello MJ Kay, Please let us know if answered proposed by Cristian_t above answers your question.Answered | 2 Replies | 6130 Views | Created by MJ Kay - Wednesday, October 20, 2010 10:54 PM | Last reply by Nikhil Shah - Thursday, October 21, 2010 5:10 PM -
1 Votes
Stored procedure timing out when called by ADO.NET
The stored procedure causing the timeout is as follows: CREATE PROCEDURE [dbo].Answered | 27 Replies | 1550 Views | Created by juniorkiran - Tuesday, August 4, 2015 12:43 PM | Last reply by juniorkiran - Tuesday, September 29, 2015 10:51 AM -
2 Votes
How to execute stored procedure from ADO.NET Data Services?
Is your stored procedure mapped to an entity?Answered | 10 Replies | 8646 Views | Created by RajeshPotineni - Friday, May 22, 2009 11:40 AM | Last reply by Phani Raju MSFT - Wednesday, May 27, 2009 11:02 PM -
0 Votes
using a stored procedure to insert only
Hi > > I wanted to get some clarification on the use of Stored Procedures and > EF (v3.5 sp1).Answered | 3 Replies | 3000 Views | Created by Magick93 - Wednesday, July 28, 2010 1:11 PM | Last reply by darnold92 - Wednesday, July 28, 2010 1:56 PM -
0 Votes
Convert Existing Stored Procedure To CLR Stored Procedure
Your stored procedure is almost completely SQL statements, so converting it to .NET would not only be slower, but possibly less secure (because users would need direct table access).Answered | 1 Replies | 7170 Views | Created by azinyama - Monday, November 5, 2012 8:55 AM | Last reply by Bob Beauchemin - Monday, November 5, 2012 5:59 PM -
0 Votes
Cannot execute stored procedure with ADO.NET Entity Framework
You have to specify the return type of the stored procedure when you create the function import.Answered | 2 Replies | 3622 Views | Created by styven1789 - Thursday, May 16, 2013 4:56 PM | Last reply by Isakavis - Monday, May 20, 2013 3:24 PM -
7 Votes
Use of GO in a Stored Procedure
You cannot call script files from stored procedures.Answered | 13 Replies | 77827 Views | Created by Leeroyster - Friday, August 20, 2010 2:35 PM | Last reply by TechVsLife2 - Wednesday, May 30, 2012 10:53 PM -
0 Votes
Using Stored Procedure in Reporting
Prodesh, if you getting error when u try to execute the Stored Procedure in DATA tab in Report but no error when u execute in Oracle DB then you need to ...Answered | 1 Replies | 4737 Views | Created by prodesh - Wednesday, May 5, 2010 5:29 PM | Last reply by Anilchow202 - Wednesday, May 5, 2010 7:14 PM -
0 Votes
Pass parameters to a stored procedure.
If you are using OLEDB Connection you need to use: EXEC SPName ?Answered | 1 Replies | 4622 Views | Created by OLAPWisdom - Tuesday, August 17, 2010 2:55 PM | Last reply by Sudeep Raj - Tuesday, August 17, 2010 2:59 PM -
2 Votes
Calling Stored procedure which uses Bulk Collect
Hi All, I have Oracle stored procedure which uses Bulk Collect and returns table type parameter as output.Answered | 4 Replies | 12561 Views | Created by Toliya - Tuesday, May 24, 2011 6:17 PM | Last reply by jamesfreddyc - Tuesday, May 31, 2011 12:25 PM -
3 Votes
Using stored Procedure in Lightswitch?
Looking forward for part 2 and also use it via wcf ria serviceAnswered | 4 Replies | 7166 Views | Created by Newbie Lightswitch - Tuesday, November 8, 2011 12:36 PM | Last reply by Newbie Lightswitch - Thursday, April 26, 2012 8:37 AM -
0 Votes
Passing parameters to a stored procedure
If you are using SQLSERVER 2008 , consider using table valued parameters.Answered | 4 Replies | 4055 Views | Created by Jona Tec - Tuesday, May 25, 2010 2:02 PM | Last reply by Naomi N - Tuesday, May 25, 2010 3:02 PM -
6 Votes
Use of "In <expression> in Stored Procedures?
Instead of x.i.VALUE(), you must use x.i.value().Answered | 8 Replies | 5042 Views | Created by Price Brattin - Monday, October 19, 2009 9:25 PM | Last reply by Adam Haines - Tuesday, October 20, 2009 5:21 PM -
0 Votes
HOw can i insert data through Ado.Net entity stored procedure?
Could you please show us the details what you want?Answered | 2 Replies | 4864 Views | Created by Mehmood Ahmed - Saturday, January 1, 2011 12:52 PM | Last reply by Jackie-Sun - Monday, January 17, 2011 8:05 AM -
0 Votes
Can you return multiple resultsets in a stored procedure using Entity Framework
When I imported my stored procedure as a Function Import it required me to select a return type (None, Scalar, Complex, or Entities).Answered | 3 Replies | 7606 Views | Created by Chockalingam S - Wednesday, July 27, 2011 6:58 PM | Last reply by dat1 - Wednesday, March 7, 2012 4:52 PM -
1 Votes
Stored procedure executed in stored procedure
Hi IqPerf, You can also use OpenQuery to select data from a Stored Procedure.Answered | 4 Replies | 5310 Views | Created by lgPerf - Wednesday, April 27, 2011 2:12 PM | Last reply by Naomi N - Wednesday, April 27, 2011 3:04 PM -
0 Votes
About Stored procedures
Things cleared up to me about stored procedure by your explanasion and the link provided by you.Answered | 2 Replies | 4609 Views | Created by Tariq Iftikhar - Monday, May 3, 2010 6:03 PM | Last reply by Tariq Iftikhar - Wednesday, May 5, 2010 6:24 PM - Items 1 to 20 of 3484814 Next ›
No announcements
