No announcements
Found 3962854 threads
-
0 Voteswhen using procedure better?
Am not sure what you mean by "difficult to maintain", but if you give the stored procedure meaningful name it is easy to find=maintain ...Answered | 5 Replies | 3447 Views | Created by Old Garey - Thursday, June 16, 2011 7:33 AM | Last reply by Uri Dimant - Thursday, June 16, 2011 8:06 AM
-
0 Votes
Convert Existing Stored Procedure To CLR Stored Procedure
In general, you'd use ADO.NET for executing SQL statements in SQLCLR procedures, but again, in this case it's not a good idea.Answered | 1 Replies | 7264 Views | Created by azinyama - Monday, November 5, 2012 8:55 AM | Last reply by Bob Beauchemin - Monday, November 5, 2012 5:59 PM -
1 Votes
Call a stored procedure from a stored procedure
If you want to perform the fetchriderpic to get the output values then insert into the template table @riderinf, the getmuttsdailyride stored procedure which you post ...Answered | 5 Replies | 1805 Views | Created by Dave Parker - Saturday, October 5, 2013 2:30 AM | Last reply by Chongtham Rajen Singh - Sunday, October 13, 2013 1:46 AM -
0 Votes
Create ECT using Nested SQL Store Procedure
Hi Jay Doshi, We need to create or declare a table to receive the output of the stored procedure via the INSERT statement.Answered | 1 Replies | 1035 Views | Created by Jay Doshi - SP - Saturday, June 18, 2016 2:49 PM | Last reply by Linda ZL - Monday, June 20, 2016 7:43 AM -
1 Votes
Stored procedure
[searchvessel1] -- Add the parameters for the stored procedure here @VesselName ...Answered | 11 Replies | 1290 Views | Created by ErikVatsvaag - Thursday, July 17, 2014 11:34 AM | Last reply by Kalman Toth - Friday, July 18, 2014 12:39 PM -
3 Votes
ExecuteNonQuery and Stored Procedure Creation
LearningVisualC2005 - If you want to execute the stored procedure, you need to use a different syntax.Answered | 11 Replies | 16720 Views | Created by LearningVisualC2005 - Sunday, August 30, 2009 7:14 AM | Last reply by siva bhamidipati - Thursday, November 1, 2012 12:43 AM -
0 Votes
stored procedure
hemaak, The procedure is working fine as per the code.Answered | 3 Replies | 1164 Views | Created by emaak - Thursday, March 13, 2014 7:31 PM | Last reply by Jayakumaur (JK) - Friday, March 14, 2014 4:05 AM -
0 Votes
Stored Procedure - Update Column
This is what I ended up with @bid int AS BEGIN SET NOCOUNT ON; -- Insert statements for procedure here IF ...Answered | 4 Replies | 1230 Views | Created by dbasnett - Thursday, January 7, 2016 7:15 PM | Last reply by Ice Fan - Thursday, January 14, 2016 9:56 AM -
0 Votes
Using If Else Condition with Stored Procedure
That silly “sp-” prefix has special meaning in T-SQL.Answered | 3 Replies | 30714 Views | Created by ShahRushabh - Tuesday, May 21, 2013 9:49 PM | Last reply by --CELKO-- - Wednesday, May 22, 2013 2:37 PM -
0 Votes
Stored Procedure Changes
You can retrieve the entire current version of the stored procedure -but not any previous versions.Answered | 2 Replies | 4645 Views | Created by KIRAN KUAMR - Wednesday, January 6, 2010 4:19 AM | Last reply by Arnie Rowland - Wednesday, January 6, 2010 6:04 AM -
3 Votes
Create a trigger using a stored procedure
- How come Suri Nagarajan understood what I mean by "Create a trigger using a stored procedure" and you don't?Answered | 7 Replies | 4844 Views | Created by skag55 - Friday, May 1, 2009 10:42 AM | Last reply by Paul White (NZ) - Tuesday, May 5, 2009 2:16 PM -
2 Votes
Using sp_start_job inside a stored procedure
When using EXECUTE AS inside the stored procedure, the user who is calling SP must have IMPERSONATE permission on destination user.Answered | 2 Replies | 3086 Views | Created by Mulak - Wednesday, January 9, 2013 4:44 PM | Last reply by Amin Sobati - Wednesday, January 9, 2013 6:43 PM -
2 Votes
Load entity sets using only stored procedures
In EF, when we use stored procs, EF treats stored procs as functions.Answered | 5 Replies | 4068 Views | Created by nlm - Monday, May 16, 2011 9:19 PM | Last reply by nlm - Friday, June 3, 2011 3:06 PM -
0 Votes
Can I use cte in my store procedure?
Hi all, Can I use cte in my store procedure?Answered | 4 Replies | 842 Views | Created by 0bamɑ - Tuesday, February 28, 2017 9:05 AM | Last reply by 0bamɑ - Tuesday, February 28, 2017 9:31 AM -
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 | 4819 Views | Created by prodesh - Wednesday, May 5, 2010 5:29 PM | Last reply by Anilchow202 - Wednesday, May 5, 2010 7:14 PM -
4 Votes
auto-increment column using stored procedure ???
0 BEGIN SET @rnd = RAND() * 1000 DELETE dbo.mytable WHERE Id = @rnd SET @cnt = @cnt - 1 END -- What is the result SELECT ...Answered | 21 Replies | 23105 Views | Created by Mohammed Abdul Muqeet - Monday, October 1, 2012 11:51 AM | Last reply by Naomi N - Wednesday, October 3, 2012 1:10 PM -
2 Votes
Using variables in Stored procedure
Can you please explain a reason for dynamic SQL in your case?Answered | 5 Replies | 4883 Views | Created by uksoftengg - Saturday, July 30, 2011 4:38 AM | Last reply by Naomi N - Sunday, July 31, 2011 5:02 AM -
3 Votes
Using stored Procedure in Lightswitch?
Please see http://blogs.msdn.com/b/eric_erhardt/archive/2012/04/17/executing-a-simple-stored-procedure-in-lightswitch.aspxAnswered | 4 Replies | 7253 Views | Created by Newbie Lightswitch - Tuesday, November 8, 2011 12:36 PM | Last reply by Newbie Lightswitch - Thursday, April 26, 2012 8:37 AM -
1 Votes
stored procedure not working, It does not drop other stored procedure
i know there is the one but in the beginning of the SP i am droping that stored procedure. still getting that errorkAnswered | 5 Replies | 1929 Views | Created by '''HuuM''' - Thursday, July 4, 2013 11:00 PM | Last reply by '''HuuM''' - Friday, July 5, 2013 4:59 AM -
0 Votes
Beginner Stored Procedure Problem in Insert using parameter
You did not set the command to StoredProc.Answered | 10 Replies | 4146 Views | Created by Rien1782 - Thursday, May 31, 2012 3:23 PM | Last reply by Rien1782 - Thursday, May 31, 2012 4:59 PM
No announcements
