Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 3,348 total)

  • RE: Backups

    Okay, I was unaware of this limitation (though I have no idea why anyone would ever even WANT to do a differential backup on master!), so I guess I learned...

    May 29, 2012 at 1:03 am

    #1493984

  • RE: Transactions 2

    roger.plowman (5/23/2012)

    And when I say "application" I mean an external application competely seperate from SQL Server.

    If you want the application to be outside SQL Server, you should avoid all programmability...

    May 23, 2012 at 2:27 pm

    #1492130

  • RE: Transactions 2

    mtassin (5/23/2012)

    Sorry, I worry more about what goes into or out of a table... the select statement at the end was an after thought. If the intention was that...

    May 23, 2012 at 7:48 am

    #1491757

  • RE: Transactions 2

    mtassin (5/23/2012)

    But this would also work as though xact_abort is on 🙂

    BEGIN try

    begin TRANSACTION

    INSERT qotd2(col1,col2,col3) VALUES (1,'x','some')

    INSERT qotd2(col1,col2,col3) VALUES (1,'Y','thing')

    INSERT qotd2(col1,col2,col3) VALUES (2,'Z','or other')

    COMMIT

    END TRY

    BEGIN CATCH

    ROLLBACK

    END catch

    SELECT * FROM qotd2

    No,...

    May 23, 2012 at 7:11 am

    #1491733

  • RE: Transactions 2

    roger.plowman (5/23/2012)

    Having the default setting to OFF basically break transactions and is a *bug* in SQL Server.

    Explicit transactions should be exactly that, explicit. This stupidity is exactly the kind of...

    May 23, 2012 at 7:09 am

    #1491731

  • RE: Transactions 2

    Neil Thomas (5/23/2012)

    So that means that when xact_abort is set to off then

    BEGIN TRANSACTION

    ...

    COMMIT TRANSACTION

    does not do as expected.

    What's the default setting on a fresh install of SQL?

    I guess...

    May 23, 2012 at 2:21 am

    #1491611

  • RE: Select Statement

    archie flockhart (5/22/2012)

    But to reply to Paul's direct question and to your list of possible results above: if I could choose, I'd return FLOAT data. It's the closest equivalent to...

    May 22, 2012 at 10:04 am

    #1491186

  • RE: Select Statement

    SQL Kiwi (5/22/2012)

    This is the point that I came here to make (and as usual Hugo arrived earlier).

    Sorry, Paul... :Whistling: (You can always try blaming time zones - though...

    May 22, 2012 at 8:48 am

    #1491139

  • RE: Select Statement

    archie flockhart (5/22/2012)

    SQL Server is smart enough, when dividing two quantities that are Decimal(2,1), to know that it can't always fit the result into Decimal(2,1), so it allows a larger...

    May 22, 2012 at 2:46 am

    #1490926

  • RE: Select Statement

    Good question (though a bit old - I think we've had lots of questions about this subject already). But not a good explanation.

    There is no data type conversion. Both operands...

    May 22, 2012 at 12:58 am

    #1490861

  • RE: Transactions 1

    wdolby (5/18/2012)

    Why does the deferred name resolution fail in this case? If I create the table, and then attempt to alter and select in the next batch, the valid...

    May 18, 2012 at 6:44 am

    #1489627

  • RE: Foreign key

    bitbucket-25253 (5/17/2012)

    Well my answer was declared to be incorrect, so went to read the explanation, following the link given ..... nada / nothing / not a word to support what...

    May 18, 2012 at 6:07 am

    #1489595

  • RE: Transactions 1

    wdolby (5/17/2012)

    I got this wrong thinking the entire batch would roll back. After playing around with it, now I know the transactions prior to the rollback will still be...

    May 17, 2012 at 3:40 pm

    #1489394

  • RE: Transactions 1

    Thomas Abraham (5/16/2012)

    Hugo Kornelis (5/16/2012)The only way I can reproduce what you are seeing, both on SQL Server 2008 R2 (I don't have 2008 vanilla) and on SQL Server 2012,...

    May 16, 2012 at 6:36 am

    #1488327

  • RE: Transactions 1

    Thomas Abraham (5/16/2012)

    Hugo Kornelis (5/16/2012)No idea what went wrong. I copied and pasted the code above, hit execute, and got two rows back. SQL Server 2012. What version are you...

    May 16, 2012 at 6:12 am

    #1488320

Viewing 15 posts - 2,116 through 2,130 (of 3,348 total)