No announcements
Found 2759229 threads
-
0 VotesHow to modify this function to accept Stored Procedure
>I need to modify this function to accept stored procedure and two parameters ...Answered | 1 Replies | 1042 Views | Created by engahmedbarbary - Friday, June 22, 2018 2:24 PM | Last reply by Stanly Fan - Monday, June 25, 2018 6:40 AM
-
0 Votes
How to optimize stored procedure without modify
How to optimize stored procedure without modify?Answered | 3 Replies | 1096 Views | Created by Vaishu00547 - Wednesday, November 25, 2015 9:06 AM | Last reply by Shanky_621 - Friday, November 27, 2015 10:56 AM -
0 Votes
Stored procedure is not accepting the parameter
let's try to read the discussion http://stackoverflow.com/questions/11359003/sql-server-stored-procedure-parameter-assignmentAnswered | 9 Replies | 2271 Views | Created by mahes - Friday, January 4, 2013 11:04 PM | Last reply by Evne Maximoy - Saturday, January 5, 2013 6:40 PM -
2 Votes
Calling a stored procedure in a function
I can not use stored procedure as i have to use that function in crystal reports.Answered | 9 Replies | 16207 Views | Created by Amit Govil (MCC) - Monday, January 10, 2011 12:35 PM | Last reply by Kent Waldrop _ - Wednesday, January 12, 2011 1:58 PM -
1 Votes
Trying to modify a system stored procedure
As others have mentioned, I would strongly recommend not altering system stored procedures.Answered | 11 Replies | 3369 Views | Created by Zoe.Ohara - Monday, February 13, 2012 4:43 PM | Last reply by Zoe.Ohara - Tuesday, February 14, 2012 11:32 AM -
1 Votes
Modify Stored Procedure from ADP vba
Instead of modifying your Stored Procedure each time you can set up all the columns that you may want to use to filter the report to ...Answered | 10 Replies | 6062 Views | Created by Dezy1 - Thursday, June 30, 2011 2:37 PM | Last reply by Dezy1 - Friday, July 15, 2011 12:01 PM -
0 Votes
Modify stored procedure Greyed out
Hi LisaKruger, you can use SSMS or T-SQL,refer to thisAnswered | 3 Replies | 1948 Views | Created by LisaKruger - Tuesday, December 17, 2019 5:10 PM | Last reply by Cris Zhan - Wednesday, December 18, 2019 4:01 AM -
0 Votes
function calling a stored procedure
Hi there, You cannot directly call a stored procedure inside a function its a limitation for functions in SQL Server.Answered | 3 Replies | 4325 Views | Created by RKBNAIR - Tuesday, June 15, 2010 7:48 PM | Last reply by KiranKumar.Y - Tuesday, June 15, 2010 8:58 PM -
0 Votes
HOw to call function imported for Stored Procedure?
Then I create stored procedure myProc in myDB.Answered | 1 Replies | 4887 Views | Created by KentZhou - Monday, August 31, 2009 7:05 PM | Last reply by Noam Ben-Ami - MSFT1 - Monday, August 31, 2009 9:44 PM -
1 Votes
Stored Procedure vs User Functions
For stored procedure you need to use the EXEC command.Answered | 5 Replies | 1434 Views | Created by Riaz Usmani - Friday, December 6, 2013 9:37 AM | Last reply by Yumei86 - Thursday, January 16, 2014 3:46 PM -
7 Votes
Difference between Function and Stored Procedure
You can use temporary tables in stored procedures, but not in functions.Answered | 9 Replies | 8334 Views | Created by czarvk - Tuesday, August 16, 2011 2:00 PM | Last reply by TechVsLife2 - Tuesday, August 16, 2011 5:54 PM -
1 Votes
Commenting a Stored Procedure or Function
I thought I will be able to quickly find a good sample of comments as I am sure I saw many good stored procedures with comments at the top (say, search for sp_who2).Answered | 3 Replies | 2303 Views | Created by eduade - Wednesday, November 2, 2011 4:45 PM | Last reply by Naomi N - Wednesday, November 2, 2011 5:31 PM -
1 Votes
Stored procedure or function ?
Another alternative in this case is to not create either a function or a stored procedure but rather use the built in COALESCE function with a WHERE clause -- much ...Answered | 4 Replies | 2131 Views | Created by guest369 - Tuesday, September 18, 2012 12:29 AM | Last reply by Kent Waldrop - Tuesday, September 18, 2012 3:01 AM -
0 Votes
Sql stored procedure that accepts array as an parameter.
Hi Bhaskar Kudalkar, You could also take a look at STRING_SPLIT (Transact-SQL) function.Answered | 5 Replies | 2801 Views | Created by Bhaskar CEAD - Thursday, December 15, 2016 12:38 PM | Last reply by Sunil Gure - Friday, December 16, 2016 6:23 AM -
1 Votes
Comparision between Stored procedure, Views and Function
Stored procedure are the most flexible DB programming objects.Answered | 4 Replies | 5885 Views | Created by Gopi Krishna Thakur - Friday, December 4, 2009 2:27 PM | Last reply by Gopi Krishna Thakur - Monday, December 14, 2009 1:36 PM -
0 Votes
Implement Stored procedure functionality in biztalk
I wouldn't look at it in an either/or situation, perhaps the best option is the break up the 'complex stored procedure' into several smaller components, each on the platform best ...Answered | 5 Replies | 1053 Views | Created by vittalaranga - Wednesday, August 20, 2014 6:03 AM | Last reply by Johns-305 - Thursday, August 21, 2014 1:57 PM -
1 Votes
Restoring database and stored procedures & functions
Everything in the database, including stored procs and functions, are included when you backup/restore a database.Answered | 1 Replies | 1224 Views | Created by Sozo Tech - Thursday, September 20, 2018 6:07 PM | Last reply by Tom Phillips - Thursday, September 20, 2018 6:18 PM -
0 Votes
Stored Procedure vs User Defined Function
Using SPs you can modify the database, but cannot use an SP in SELECT statement.Answered | 6 Replies | 12906 Views | Created by ashish.deshpande - Thursday, October 13, 2011 8:24 AM | Last reply by Naomi N - Friday, October 14, 2011 6:51 PM -
0 Votes
Can not modify stored procedure on Azure
Now I'm trying to modify a stored procedure using Microsoft SQL Server Management Studio (the latest edition - 2014).Answered | 2 Replies | 1055 Views | Created by assafdsb - Sunday, October 18, 2015 10:14 AM | Last reply by Andrew.Fryer - Monday, October 19, 2015 1:54 PM -
1 Votes
Replace function calls in stored procedure
Now, you talk about a function that returns a list of things, and I guess that this is a multi-statement function.Answered | 2 Replies | 869 Views | Created by SBHKR - Thursday, August 11, 2016 7:55 AM | Last reply by Erland Sommarskog - Thursday, August 11, 2016 11:38 AM - Items 1 to 20 of 2759229 Next ›
No announcements
