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

    May 16, 2011 at 11:03 am

    #1325304

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

    May 16, 2011 at 10:54 am

    #1325293

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

    May 16, 2011 at 10:42 am

    #1325278

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

    May 16, 2011 at 10:38 am

    #1325275

  • 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?

    May 16, 2011 at 7:39 am

    #1325042

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

    May 13, 2011 at 12:01 pm

    #1324495

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

    May 13, 2011 at 11:15 am

    #1324478

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

    May 13, 2011 at 9:11 am

    #1324375

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

    May 13, 2011 at 8:00 am

    #1324301

  • RE: Today's Random Word!

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

    May 13, 2011 at 7:28 am

    #1324281

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

    May 13, 2011 at 7:28 am

    #1324280

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

    May 13, 2011 at 6:35 am

    #1324241

  • RE: Today's Random Word!

    WOTD: Edited

    May 13, 2011 at 6:25 am

    #1324234

  • 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?

    May 13, 2011 at 6:07 am

    #1324225

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

    May 12, 2011 at 11:43 am

    #1323874

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