Viewing 9 posts - 1 through 9 (of 9 total)
This was a great article. I implemented this on a cluster we are putting in production this weekend. I thoroughly tested it and it worked like a charm....
October 25, 2013 at 11:34 am
I know the point you were trying to get across, but using sp_executesql is not needed to print the value of the variable. It could simply be written as...
January 3, 2013 at 7:53 am
I wrote a script to extract out the sp_executesql and parameter values prior to running the function. This allowed me to create the query templates.
September 20, 2010 at 12:52 pm
I did see the post. I also looked online for this information and could not find anything specific. The person that told me about these issues managed a...
September 20, 2010 at 10:11 am
Do you want to back up and restore the database or just pump the data?
October 2, 2003 at 7:21 pm
I found a way around this issue. Thanks for the help.
October 2, 2003 at 7:20 pm
That's what I thought. I used IF statements instead. Thanks for your help.
October 2, 2003 at 7:16 pm
Andy,
What you did is exactly what I need to do. I stated that there were varying amounts of parameters because I have more than one stored procedure.
For example,
SP_ID ...
September 29, 2003 at 7:31 am
Thank you for your comments. I will use your solution.
September 29, 2003 at 7:15 am
Viewing 9 posts - 1 through 9 (of 9 total)