Forum Replies Created

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

  • RE: SET or SELECT to assign a default value to a nullable variable

    Alexeins (5/17/2012)

    What is best way to write this statement?

    1)

    DECLARE @L_ZERO INT

    SELECT @L_ZERO = IdMyTable FROM MyTable WHERE ColumnRef = 1000

    SELECT ISNULL(@L_ZERO, 0)

    OR

    2)

    DECLARE @L_ZERO INT

    SET @L_ZERO = ISNULL((SELECT IdMyTable FROM MyTable...

    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 17, 2012 at 10:38 am

    #1489183

  • RE: Setting the Identity in a temp table using a variable

    SJanki (5/17/2012)

    I have a table Allocations with coulmns AllocationID , PaymentID , ….

    AllocationID is a PK.

    Depending on certain condition I have to insert multiple records in Allocations table.

    I get the...

    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 17, 2012 at 10:35 am

    #1489176

  • RE: Forgotten Tipples

    I tasted homemade grape schnapps one summer when I was in Austria. Delicious! I need to go find a good recipe for it to see if I can make 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 17, 2012 at 6:43 am

    #1488962

  • RE: Must declare the scalar variable

    saidapurs (5/16/2012)

    I apriciate your responce & i agree with you but issue is i am not yet wrote any SP in my life. so while adding this once i requested...

    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:37 am

    #1488551

  • 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

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