Forum Replies Created

Viewing 15 posts - 4,426 through 4,440 (of 9,722 total)

  • RE: Question: Immediate Exit of Stored Procedure?

    ColdCoffee,

    RAISEERROR would definitely work, but in this case, the dev specified that he wanted to exit without raising an error. Which limits the options down to RETURN().

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 10:08 am

    #1488532

  • RE: Question: Immediate Exit of Stored Procedure?

    mtassin (5/16/2012)

    capn.hector (5/16/2012)

    in any of my procedures that are user accessible i have a block at the beginning something like this:

    IF @Input <> (good input)

    BEGIN

    SELECT 'you have bad input'

    RETURN

    END

    kills it...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 9:37 am

    #1488498

  • RE: Question: Immediate Exit of Stored Procedure?

    Matt Miller (#4) (5/16/2012)

    Now - the examples aren't very good since they encapsulate everything in IF statements...

    Exactly the problem I was having when reading the entries. I hate BOL examples...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 9:10 am

    #1488468

  • RE: Question: Immediate Exit of Stored Procedure?

    Thank everyone for the relevant highlights and links. I can't believe I missed that.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 9:07 am

    #1488464

  • RE: Question: Immediate Exit of Stored Procedure?

    Really? The RETURN statement will stop a proc in mid execution?

    I'm looking over BOL on that and don't see any statements to that effect. That's why I posted here.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 8:36 am

    #1488445

  • RE: Must declare the scalar variable

    saidapurs (5/16/2012)

    If possible please do the changes & update me.

    Just an FYI: This is a bad way to phrase a request for help. It raises the hackles of forum regulars...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 8:20 am

    #1488429

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/16/2012)

    jcrawf02 (5/16/2012)

    Brandie Tarvin (5/16/2012)

    L' Eomot Inversé (5/15/2012)

    We have idiocies like proposals for an "absolute right to be forgotten" which means, for example, that someone serving a prison sentence for...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 6:52 am

    #1488344

  • RE: Today's Random Word!

    SQLRNNR (5/16/2012)

    RBarryYoung (5/15/2012)

    SQLRNNR (5/15/2012)

    Brandie Tarvin (5/14/2012)

    Daniel Bowlin (5/14/2012)

    Regional

    Sectional

    Couch

    Slouch

    Crouch

    Barty

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 6:14 am

    #1488323

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (5/15/2012)

    We have idiocies like proposals for an "absolute right to be forgotten" which means, for example, that someone serving a prison sentence for rape or for murder...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 16, 2012 at 6:14 am

    #1488322

  • RE: Are the posted questions getting worse?

    Tom,

    Does EU data protection laws define a difference between sensitive information and personal indentifying information?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 15, 2012 at 11:55 am

    #1487910

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (5/14/2012)

    All ye All ye, Now hear this

    How about commenting on opc.three's post to encourage / discourage him in writing a spackle article:

    http://www.sqlservercentral.com/Forums/Topic1298803-1292-2.aspx#bm1299757

    Per your request, opc.three has been...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 15, 2012 at 5:09 am

    #1487609

  • RE: Today's Random Word!

    Daniel Bowlin (5/14/2012)

    Regional

    Sectional

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 14, 2012 at 7:07 am

    #1487082

  • RE: Are the posted questions getting worse?

    Random topic choice:

    Anyone know of any good internet articles on the history of the Greek Chorus? I can't seem to find my theatre history books at home and it's driving...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 14, 2012 at 7:06 am

    #1487080

  • RE: Are the posted questions getting worse?

    "Broken" works. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 14, 2012 at 4:47 am

    #1487021

  • RE: Common questions asked in SQL Server DBA Interview

    Jeff Moden (5/14/2012)

    Brandie Tarvin (5/14/2012)

    What is the wing span of an unladen swallow?

    It depends. What is the age and current speed of the swallow?

    I don't know.

    <Aaaaaaaaarrrrrrrrggggghhhhhhhhhh>

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 14, 2012 at 4:46 am

    #1487019

Viewing 15 posts - 4,426 through 4,440 (of 9,722 total)