Post reply

Field Lengths

  • October 11, 2013 at 7:37 am

    #1657911

    Thanks for the great question! EZ one for Friday. 🙂


    Everything is awesome!

  • October 11, 2013 at 10:24 am

    #1657968

    Thanks for the question Steve! I know a number of developers who have probably never used datalength. It is good to see questions around functions that aren't used every day.

  • October 11, 2013 at 3:40 pm

    #1658031

    I almost got it wrong because of miscounting the number of extra columns. Was looking for a "10" answer in the wrong position. The only reason I ended up getting it right was that there was only a single answer with a "10" in the position where I was looking.

    All those extra columns made the question more complex without really adding something; other than that it was a fair question (just a shame there was no option "10" for the LEN(d) colum; I'm sure some people would have fallen for that)

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • October 12, 2013 at 1:47 am

    #1658058

    Hugo Kornelis (10/11/2013)(just a shame there was no option "10" for the LEN(d) colum; I'm sure some people would have fallen for that)

    There is; the last choice: 1,1,1,1,40,1,10,2,1

    But I guess there is a typo as it`s written 10.2 in the QoTD.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • October 15, 2013 at 2:28 pm

    #1658709

    Excellent question, thanks!

  • October 15, 2013 at 3:35 pm

    #1658737

    I am surprised that the number of correct answers is well above the average (81 percent): it took me several minutes to figure it out.

    Thanks for the question, Steve!

  • October 31, 2013 at 3:11 am

    #1662948

    nice question thanks

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply