Viewing 13 posts - 7,471 through 7,484 (of 7,484 total)
Somewhat incomplete answer: an important part of the sp is the option to raise or not raise an error if the sysname parameter is invalid. (unless that has changed in...
January 26, 2009 at 3:03 pm
J (11/6/2008)
No. YOU ARE wrong.
It does not matter if there are duplicates or not, because the question specifically mentioned that there were no duplicates.
So "UNION ALL"...
January 26, 2009 at 2:49 pm
For SQL 2000 (and the question explicitly includes "before SQL 2005") there is no way of specifying ignore_dup_key for a primary key. Any attempt to specify "with ignore_dup_key" in...
January 26, 2009 at 2:44 pm
It threw me. I assumed SSMS would behave the same way as isqlw so gave the wrong answer. I'm inclined to consider the SMSS behaviour a bug, as making...
January 26, 2009 at 1:03 pm
Piotr Rodak (11/22/2008)
The Hash Match operator that is used whenoption (hash union)
is used apparently sorts data anyway, just NULLs are added to the end of the output.Piotr
The hash...
January 26, 2009 at 11:55 am
TheSQLGuru (1/6/2009)
.... here is a quickie example. as the number of rows (or joins) goes up it gets much worse
....
This example may be rather misleading, depending on...
January 6, 2009 at 1:48 pm
Matt Whitfield (1/6/2009)
January 6, 2009 at 5:19 am
David McKinney (1/2/2009)
ANY SOLUTION based on sysdepends isn't going to work.
The obvious solution based on sysdepends - running alterproc for the SP with no changes before using sysdepends - works...
January 2, 2009 at 1:43 pm
TheSQLGuru (1/2/2009)
1) Tom, can you or anyone else give an example of UPDATEs that cannot be done without using the FROM clause that can be done with it's use?
2) I...
January 2, 2009 at 12:09 pm
Jeff Moden (1/1/2009)
npfitzner (1/1/2009)
Tom.Thomson (1/1/2009)
He wants to remove the From clause from the Update statement? Seriously?No - I think that's what the 😉 was for.
🙂
Yes! ...
January 2, 2009 at 5:57 am
Jeff Moden (12/31/2008)
January 1, 2009 at 11:28 am
In my previous post please substitute "or" fro "and" in "FAST_FORWARD and STATIC". Tom.
December 31, 2008 at 5:28 am
Just add "FAST_FORWARD" and "STATIC" to the cursor definition and the cursor method will run as fast as your non-cursor method (and for large datasets it will probably...
December 31, 2008 at 5:15 am
Viewing 13 posts - 7,471 through 7,484 (of 7,484 total)