Forum Replies Created

Viewing 13 posts - 7,471 through 7,484 (of 7,484 total)

  • RE: Object Names

    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...

  • RE: UNION error

    J (11/6/2008)


    Sorry - you were wrong

    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"...

  • RE: IGNORE_DUP_KEY

    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...

  • RE: Go go go?

    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...

  • RE: Predict output

    Piotr Rodak (11/22/2008)


    The Hash Match operator that is used when option (hash union) is used apparently sorts data anyway, just NULLs are added to the end of the output.

    Piotr

    The hash...

  • RE: Cursors Be Gone!

    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...

  • RE: Cursors Be Gone!

    Matt Whitfield (1/6/2009)


    Sorry Jeff - wasn't clear in what I said. What I meant to say is that I don't know a way that you can create a non-unique clustered...

  • RE: Tables referenced by a stored proc (2000)

    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...

  • RE: Cursors Be Gone!

    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...

  • RE: Cursors Be Gone!

    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! ...

  • RE: Cursors Be Gone!

    Jeff Moden (12/31/2008)


    Ok... now I'm getting really afraid for you guys... :hehe: you're talking about this like you use cursors and you're listening to the guy who wants to remove...

  • RE: Cursors Be Gone!

    In my previous post please substitute "or" fro "and" in "FAST_FORWARD and STATIC". Tom.

  • RE: Cursors Be Gone!

    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...

Viewing 13 posts - 7,471 through 7,484 (of 7,484 total)