Forum Replies Created

Viewing 15 posts - 256 through 270 (of 355 total)

  • RE: TRUNCATE in TRANSACTION

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

    Spin it however you want it, young 40+ years ago, AND programming, is still not young today :w00t:.

    My first exposure to computers was a mainframe using magnetic core memory....

    January 5, 2011 at 9:13 am

    #1269578

  • RE: TRUNCATE in TRANSACTION

    sjimmo (1/5/2011)

    Nice way to make some feel soo old:hehe:

    I agree. I was programming in the late 70's (not SQL) so I am way older but don't want to admit...

    January 5, 2011 at 8:54 am

    #1269563

  • RE: TRUNCATE in TRANSACTION

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

    Victor Kirkpatrick (1/5/2011)

    Columns in the IN clause! 22 years of sql and that was a first. You're never too old to learn. Thanks!

    Is SQL really THAT old? :hehe:

    I...

    January 5, 2011 at 6:50 am

    #1269468

  • RE: TRUNCATE in TRANSACTION

    sjimmo (1/4/2011)

    Got it wrong, but learned something - which is the key

    Hugo,

    The knowledge tested is good, but the way the question has been built suggests to me that the author...

    January 4, 2011 at 6:41 am

    #1268898

  • RE: TRUNCATE in TRANSACTION

    Hugo Kornelis (1/4/2011)

    I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back, and then...

    January 4, 2011 at 3:02 am

    #1268825

  • RE: SELECT TOP

    I didn't like this question. I did get it right because I figured it would return 'Ann' most of the time but as the author said, it cannot be...

    December 21, 2010 at 2:50 am

    #1264962

  • RE: NULL Values and Joins

    abcd

    4join14join2

    4join14join2

    2join32one

    2join32one

    1oneNULLNULL

    NULLNULLNULLtwo

    NULLNULLNULLthree

    The reason I missed the answer is that I thought if you order by column d, "two" would be at the bottom. Doesn't "two" come after "three" in an...

    December 20, 2010 at 8:36 am

    #1264656

  • RE: T-sql

    True that this question has been asked multiple times in different ways but I finally got an easy point without having to think too much.

    December 17, 2010 at 3:00 am

    #1263963

  • RE: T-SQL

    john.arnott (12/16/2010)

    There could be a super-secret release that offers the expression of a day number in base nineteen.;-):hehe::-D:-)

    I did some research on the Mayan calendar and it seems they used...

    December 16, 2010 at 11:21 am

    #1263618

  • RE: T-SQL

    Carlo Romagnano (12/16/2010)

    cengland0 (12/16/2010)

    Carlo Romagnano (12/16/2010)

    the Mayan calendar shows the world will end on December 21, 2012 anyway.

    Mayan calendar BUG: 12/12/2012 is the end.

    :-D:-D:-D

    Actually, it's 12/21/2012

    It depends on "Regional Settings".

    :-D:-D:-D:-D

    I...

    December 16, 2010 at 3:41 am

    #1263361

  • RE: T-SQL

    Carlo Romagnano (12/16/2010)

    the Mayan calendar shows the world will end on December 21, 2012 anyway.

    Mayan calendar BUG: 12/12/2012 is the end.

    :-D:-D:-D

    Actually, it's 12/21/2012

    December 16, 2010 at 3:20 am

    #1263350

  • RE: T-SQL

    OCTom (12/15/2010)

    The Y2K rush was exciting, boring, tedious, scary...

    This question does make one wonder why 2-digit years are still in use. However, since SQL Server dates only go out...

    December 15, 2010 at 8:45 pm

    #1263268

  • RE: T-SQL

    John Mitchell-245523 (12/15/2010)

    I got this right, but I think the question should have been qualified with something like "on an instance installed with the default settings". Otherwise the answer...

    December 15, 2010 at 3:47 am

    #1262723

  • RE: What is the result of the following query

    Hugo Kornelis (12/10/2010)

    Except it doesn't.

    If you copy/paste the above in an SSMS query window and hit execute, you get "Command(s) completed successfully."

    Exactly. I try to answer the questions without...

    December 10, 2010 at 6:10 am

    #1260995

  • RE: What is the result of the following query

    I got it right but I had to think about this one.

    I thought the error was going to be caused by not having a space between the two commands.

    Set...

    December 10, 2010 at 3:20 am

    #1260943

Viewing 15 posts - 256 through 270 (of 355 total)