No announcements
Found 742266 threads
-
0 Votes
Dynamic select in stored procedure
So why do you want to do this in a stored procedure?Answered | 3 Replies | 2549 Views | Created by Doraemon_3 - Thursday, February 2, 2012 7:15 AM | Last reply by Erland Sommarskog - Thursday, February 2, 2012 9:30 AM -
0 Votes
dynamic execution of a stored procedure
Hi Darwin101, Please refer to the following ...Answered | 1 Replies | 3608 Views | Created by Darwin101 - Monday, October 3, 2011 3:09 PM | Last reply by Eileen Zhao - Tuesday, October 4, 2011 8:46 AM -
1 Votes
Calling Stored Procedures Dynamically
I think I may have found a work around to this issue of Dynamically calling Stored Procedures.Answered | 3 Replies | 2584 Views | Created by DaveH984 - Monday, August 6, 2012 10:28 AM | Last reply by Mike Yin - Sunday, August 12, 2012 11:56 AM -
0 Votes
Dynamic SQL Stored procedure
> I am trying to write a dynamic SQL stored procedure.Answered | 4 Replies | 7784 Views | Created by Dheeraj M Uthaiah - Saturday, October 13, 2012 5:19 AM | Last reply by --CELKO-- - Saturday, October 13, 2012 2:58 PM -
0 Votes
Convert Dynamic SQL into store procedure
I do not think it is good practice to clean up procedure cache.Answered | 3 Replies | 1417 Views | Created by Daizy Desai - Monday, June 2, 2014 4:00 PM | Last reply by Uri Dimant - Thursday, June 5, 2014 5:52 AM -
0 Votes
dynamic sql vs stored procedures
This article on my web site discusses dynamic SQL in detail.Answered | 2 Replies | 3570 Views | Created by Bryan Rev - Thursday, January 19, 2012 12:37 AM | Last reply by Erland Sommarskog - Thursday, January 19, 2012 8:39 AM -
1 Votes
Help to Dynamic Stored procedure
Hey all I'am currently trying to implement some dynamic parameters "@EventCategory, @Category and @City" to the RSSRows select statement below, but can't seem to ...Answered | 5 Replies | 2426 Views | Created by Henrik Stensgaard - Tuesday, February 14, 2012 4:23 PM | Last reply by Erland Sommarskog - Tuesday, February 14, 2012 11:13 PM -
0 Votes
Create a dynamically ordered stored procedure
If you want to do this without dynamic sql, you can try this tricky solution: /* @Firstfield can be in ( 1: selected , 0: not-selected ) @FirstfieldAscDesc can be ...Answered | 3 Replies | 1069 Views | Created by Mad-Dog - Wednesday, October 9, 2013 6:32 PM | Last reply by Saeid Hasani - Thursday, October 10, 2013 7:54 AM -
0 Votes
How to create dynamic Insert Query Stored Procedure
Writing one generic INSERT stored procedure is a very bad idea.Answered | 6 Replies | 13205 Views | Created by Ajay Singh Rawat - Friday, December 16, 2011 11:20 AM | Last reply by Naomi N - Friday, December 16, 2011 3:09 PM -
0 Votes
A Stored Procedure to Create a Set of Stored Procedures
I am also doing same kind of job through the dynamic sql" Education is the beginning of transformation.Answered | 3 Replies | 4293 Views | Created by Nick Olsen - Tuesday, October 19, 2010 2:52 PM | Last reply by Nick Olsen - Tuesday, October 19, 2010 3:11 PM -
2 Votes
SSRS - Stored procedure with Dynamic SQL Query
SET FMTONLY ON; EXEC MyStoredProcedure SET FMTONLY OFF; A similar post regarding this issue: ...Answered | 7 Replies | 4423 Views | Created by Hruthikesh - Tuesday, May 13, 2014 6:23 PM | Last reply by Elvis Long - Tuesday, May 20, 2014 1:41 AM -
0 Votes
Stored procedure with dynamic parameters in Insert/Update
Hi All, During the development stage, we found that there are possibility of changing parameter of stored procedure (add/remove/change) etc so for ...Answered | 2 Replies | 1705 Views | Created by Shailesh B Davara - Wednesday, February 20, 2013 7:55 AM | Last reply by Michael Samteladze - Wednesday, February 20, 2013 9:22 AM -
0 Votes
RECURSIVE IN DYNAMIC STORED PROCEDURE
CREATE TABLE PMOne(SNO INT, FullNAME VARCHAR(20), AddressToDelete VARCHAR(100)) GO CREATE TABLE PMTwo(SNO INT, FullNAME VARCHAR(20), AddressToDelete ...Answered | 7 Replies | 3233 Views | Created by khushi_10 - Wednesday, June 22, 2011 11:23 AM | Last reply by Adam_Turner - Wednesday, June 22, 2011 1:05 PM -
1 Votes
Stored Procedure for updating dynamic columns in a table
If you want to use stored procedures, the simplest is probably to have a stored procedures that accepts parameters for all columns and then update all columns.Answered | 10 Replies | 22114 Views | Created by Ton-Ton Keaton - Wednesday, February 12, 2014 7:52 AM | Last reply by Ton-Ton Keaton - Wednesday, February 12, 2014 11:08 PM -
0 Votes
convert a dynamic query in to stored procedure
If that is the case, instead of writing a fairly complex dynamic query in a stored procedure, you could consider doing multiple simple update ...Answered | 6 Replies | 852 Views | Created by baiju krishnan - Sunday, February 21, 2016 6:34 AM | Last reply by Sam Zha - Monday, February 22, 2016 8:36 AM -
0 Votes
Store Procedure
By multiple if you mean dynamic params, than SQL Server do not provide any such mechanism.Answered | 4 Replies | 3513 Views | Created by Surjya - Friday, March 30, 2012 5:38 AM | Last reply by Manoj Pandey (manub22) - Friday, March 30, 2012 6:26 AM -
0 Votes
Selecting VIEW dynamically from a stored procedure
This way you could avoid the dynamic SQL path.Answered | 6 Replies | 5404 Views | Created by steve321321 - Friday, September 19, 2008 4:20 AM | Last reply by Uri Dimant - Sunday, August 29, 2010 10:23 AM -
1 Votes
Stored procedure
Also, when I execute the stored procedure in SQL all commands runs successfully.Answered | 11 Replies | 1106 Views | Created by ErikVatsvaag - Thursday, July 17, 2014 11:34 AM | Last reply by Kalman Toth - Friday, July 18, 2014 12:39 PM -
0 Votes
Store procedure enviroment question
Is it a good practice to write store procedures and called by SSRS for most of the reports?Answered | 4 Replies | 2174 Views | Created by stephen huo - Monday, June 11, 2012 10:26 PM | Last reply by stephen huo - Tuesday, June 12, 2012 9:11 AM -
0 Votes
stored procedure
From, @param4 = @To --Exec (@sql) you can also use table-valued parameter http://msdn.microsoft.com/en-us/library/bb675163.aspx but again you need to execute ...Answered | 5 Replies | 1063 Views | Created by Mohan DBA - Wednesday, September 25, 2013 6:02 AM | Last reply by SaravanaC - Wednesday, September 25, 2013 6:48 AM - Items 1 to 20 of 742266 Next ›
No announcements