Forum Replies Created

Viewing 15 posts - 331 through 345 (of 658 total)

  • RE: T-SQL

    pchirags (1/4/2013)

    the options says NULL Values, not exactly one NULL.

    create table temp

    (a int, b int, constraint ukTemp unique (a,b))

    go

    insert into temp values (null,null),(null,1),(1,null)

    go

    Three rows contain Null values. One of them...

    January 4, 2013 at 8:34 am

    #1573780

  • RE: T-SQL

    mtassin (1/4/2013)

    Since Uniqueness constraints basically enforce what they do with Unique Indexes, I was thinking that nobody uses Unique constraints anymore and just uses unique indexes since they can be...

    January 4, 2013 at 7:30 am

    #1573753

  • RE: T-SQL

    I don't really like this question.

    "They are not the same, but they both enforce uniqueness of the column on which they are defined"

    assumes that they can both only be...

    January 4, 2013 at 7:24 am

    #1573749

  • RE: Finding New Years Eve

    Hugo Kornelis (1/3/2013)

    For a method to find "last New Year's Eve" that works correctly in 2013 only, my suggested code would be

    SELECT CAST('20121231' AS datetime);

    <Like!>

    January 3, 2013 at 3:08 am

    #1573231

  • RE: New Year's Math

    I got it right because although I couldn't be bothered working through the code, it was clearly adding lots of things to @NewYearsEve so the answer was never going to...

    January 3, 2013 at 2:17 am

    #1573210

  • RE: Round And Numaric

    Raghavendra Mudugal (1/2/2013)

    Hope this helps

    It certainly does - and reminds my why I reluctantly stick to float for arithmetic!

    Here's the correct reference

    http://msdn.microsoft.com/en-us/library/ms190476.aspx

    January 2, 2013 at 3:42 am

    #1572798

  • RE: Round And Numaric

    dineshbabus (1/2/2013)

    In first statement both values are rounded to 0 precision then how come on dividing it returns 6 digits after decimal point.

    Pls xplain .

    That's the only non-obvious part of...

    January 2, 2013 at 3:08 am

    #1572785

  • RE: Finding New Years Eve

    Steve Jones - SSC Editor (1/1/2013)

    I changed to question to exclude Jan 31, this that doesn't work.

    Jan 30 won't work either. Jan 29 will only work in leap years.

    January 2, 2013 at 2:56 am

    #1572781

  • RE: RAID

    Can't see the need for a Microsoft reference on a question that's about something universal. But I agree with Tom - I'd never use a Wikipedia reference as sole support...

    January 2, 2013 at 2:45 am

    #1572776

  • RE: Divide by zero

    That required rather more brain cells than I was expecting to need on Christmas Eve :hehe:

    Glad to see that option 5 really should be correct, I'd started to think I...

    December 24, 2012 at 6:19 am

    #1571261

  • RE: UNIQUE constraint

    Hugo Kornelis (12/20/2012)

    The Microsoft implementation of the UNIQUE constraint is non-standard, and therefor dangerous - people with experience in other DMBS'es who switch to SQL Server can easily run into...

    December 20, 2012 at 2:10 am

    #1570451

  • RE: UNIQUE constraint

    SQLRNNR (12/20/2012)

    ...

    This demonstrates that multiple null values is possible and that multiple null values is even possible within each of the columns so long as all of the columns together...

    December 20, 2012 at 2:09 am

    #1570450

  • RE: SET Options - 1

    Thanks for the easy question to end the week!

    😉

    December 14, 2012 at 6:39 am

    #1568671

  • RE: Renaming a procedure

    Hugo Kornelis (12/12/2012)

    The speculative answer: Documenting behaviour is one way to "close" a bug deemed not important enough to warrant fixing.

    Makes sense. I wish I could get away with that...

    December 12, 2012 at 6:35 am

    #1567858

  • RE: Renaming a procedure

    Hugo Kornelis (12/12/2012)

    Using sp_rename to rename a programmability item does not change its definition in sys.sql_modules. That's why Books Online recommends to use DROP / CREATE instead.

    I've never quite...

    December 12, 2012 at 3:38 am

    #1567794

Viewing 15 posts - 331 through 345 (of 658 total)