Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 3,348 total)

  • RE: BIT Primary Key

    wolfkillj (1/29/2013)

    (And yes, I know I spelled DR0P TABLE with a zero instead of an "O". In posting on this forum, I have discovered the my employer seems to have...

    January 29, 2013 at 9:11 am

    #1582200

  • RE: CHOOSE - 1

    bitbucket-25253 (1/29/2013)

    Unfortunately the criticism touches me deeply

    I am sorry to hear that you feel so hurt. You made a mistake. So what? We're only humans, we're supposed to make mistakes....

    January 29, 2013 at 9:08 am

    #1582199

  • RE: CHOOSE - 1

    bitbucket-25253 (1/29/2013)

    davoscollective

    A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1 and both...

    January 29, 2013 at 8:25 am

    #1582165

  • RE: BIT Primary Key

    jdamm (1/29/2013)

    Although the "conversion" of a number to either a 1 or a 0 bit - I did appreciate the "look at the most significant bit - if it's 1...

    January 29, 2013 at 6:37 am

    #1582100

  • RE: BIT Primary Key

    ronmoses (1/29/2013)

    Gotta love a table that will only ever accept one row. 😀

    Ron

    That can actually be quite useful. For instance for applications that do stuff on the current date, but...

    January 29, 2013 at 5:37 am

    #1582055

  • RE: Aggregates

    Thanks for the explanation, Tom! 😉

    January 29, 2013 at 5:27 am

    #1582051

  • RE: BIT Primary Key

    A good and creative question, hampered by some flaws in the explanation.

    The reason the number 2 is converted to bit 1 is not because of its bit pattern, but for...

    January 29, 2013 at 1:46 am

    #1581935

  • RE: Aggregates

    L' Eomot Inversé (1/28/2013)

    Hugo Kornelis (1/28/2013)

    manik123 (1/28/2013)

    nice question... but bit confusion about STDEVP... how we can use for our developement? any examples....????:-)

    If you develop code that has to compute the...

    January 28, 2013 at 2:57 pm

    #1581825

  • RE: Aggregates

    manik123 (1/28/2013)

    nice question... but bit confusion about STDEVP... how we can use for our developement? any examples....????:-)

    If you develop code that has to compute the statistical standard deviation for the...

    January 28, 2013 at 4:13 am

    #1581536

  • RE: CHOOSE - 1

    Tough I applaud the effort to create questions on new SQL2012 functionality, I really see nothing positive about this question.

    First, without AdventureWorks2012 it's impossible to answer the question. True, everyone...

    January 28, 2013 at 4:09 am

    #1581533

  • RE: Question of the day

    L' Eomot Inversé (1/25/2013)

    I'm very surprised that more than half (113 people out of 218) so far have got it wrong. Maybe people don't use coalesce? Are...

    January 25, 2013 at 4:11 am

    #1580930

  • RE: Question of the day

    manik123 (1/25/2013)

    i am bit confusion about the point "The return type of COALESCE does depend on the data type precedence rules". can u explain any body?????

    See http://msdn.microsoft.com/en-us/library/ms190309.aspx for the data...

    January 25, 2013 at 1:40 am

    #1580862

  • RE: T-SQL Restore Script Generator

    Thanks for the quick and enlightening reply, Paul!

    January 24, 2013 at 2:07 am

    #1580419

  • RE: T-SQL Restore Script Generator

    Thanks for sharing your script, Paul!

    I do have a question, though. In SSMS, when I bring up the restore dialog, I can select a point in time and then have...

    January 24, 2013 at 1:24 am

    #1580403

  • RE: Relational Model versus XML

    I think the correct answer should be worded slightly differently: "Either one can be appropriate" (italics used to emphasize changed part).

    If forced to make a choice based on the limited...

    January 24, 2013 at 1:15 am

    #1580402

Viewing 15 posts - 1,861 through 1,875 (of 3,348 total)