Forum Replies Created

Viewing 15 posts - 5,956 through 5,970 (of 9,707 total)

  • RE: Return rows affected by an UPDATE in an SP

    Ray K (5/16/2011)


    Brandie Tarvin (5/16/2011)


    What's going on with the @Plist thing? Why do you have that in the final execute?

    Mainly force of habit -- I copy/pasted from some other code...

  • RE: Return rows affected by an UPDATE in an SP

    Ray K (5/16/2011)


    When I tried calling the SP, I got the 'Must declare the scalar variable "@Result".' message.

    Declare @Result int;

    Execute TestProc 'ID','Email', @Result output;

    That's how you call an output variable....

  • RE: Return rows affected by an UPDATE in an SP

    You might want to check the difference between your actual code and your posted code.

    I've done that before. Changed my code to post on the forums and, in the...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/16/2011)


    We're trying to get the Rally here in Denver, so maybe we'll get some of you to come way out west 😉

    Oh, I would definitely...

  • RE: Today's Random Word!

    crookj (5/16/2011)


    Ray K (5/16/2011)


    WOTD: Rainy day and Monday

    "Always get me down...."

    GAH!

    Is that a word?

  • RE: Know Your SQL Objects

    Ninja's_RGR'us (5/13/2011)


    SanDroid (5/13/2011)


    Ninja's_RGR'us (5/13/2011)


    SanDroid (5/13/2011)


    I believe the author wanted to enforce in us the learning that we have two types of Extents that are owned differantly. He has certainly suceeded...

  • RE: Know Your SQL Objects

    Paul Randal (5/13/2011)


    Steve - I got this wrong because your wording is broken. Extents can NOT be owned by multiple objects. When an extent is a mixed extent, it is...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/13/2011)


    Brandie Tarvin (5/13/2011)


    Why am I not surprised over the quibbling on the QOTD?

    I really wasn't trying to trick anyone. Honest.

    I have to admit the...

  • RE: Know Your SQL Objects

    SanDroid (5/13/2011)


    Brandie Tarvin (5/13/2011)


    Don't believe me? Then I have an interesting exercise for you to try.....

    I would suggest submitting a question and then defending that question in this Forum.

    You mean...

  • RE: Today's Random Word!

    Okay, Ray. You just made my day. @=)

  • RE: Are the posted questions getting worse?

    Why am I not surprised over the quibbling on the QOTD?

    I really wasn't trying to trick anyone. Honest.

  • RE: Know Your SQL Objects

    tabraham 36699 (5/13/2011)


    This question reminds me of my grad school and teaching days. Some people people feel that to make a challenging question, there has to be a semantic trick...

  • RE: Today's Random Word!

    WOTD: Edited

  • RE: Are the posted questions getting worse?

    Alvin Ramard (5/13/2011)


    Had to laugh when Grant mentioned DBCC TimeWarp in a presentation. 😀

    Oh, you have to share. In what context did he mention it?

  • RE: Today's Random Word!

    SQLRNNR (5/12/2011)


    crookj (5/12/2011)


    Ray K (5/12/2011)


    WOTD: ""

    (As you can see, I don't have much to say today . . . ;-))

    WOTD - Flashback (As in the earlier posts about the Sounds...

Viewing 15 posts - 5,956 through 5,970 (of 9,707 total)