Post reply

Cast in Varchar with different options

  • July 16, 2012 at 7:10 am

    #1513048

    Thanks, It is good point

  • July 16, 2012 at 7:25 am

    #1513054

    rhythmk (7/16/2012)

    It is upto you if you want to learn you can use in such cases where it is hard to count the characters (exactly 30 in b option) otherwise one can directly run the query in SSMS and check the output.

    But I always use honesty is best policy to learn and test.:-)

    I agree that running of a different query is honest. But I prefer questions where no tools other than brain and eyes are needed.

    For example the length of a literal as '1234567890123456789012345678901' can be counted quite quickly.


    See, understand, learn, try, use efficient
    © Dr.Plch

  • July 16, 2012 at 8:09 am

    #1513090

    Nice question for a Monday. We've had ones like this recently enough that I would have expected the percent of correct answers to be closer to 100%. Maybe we have had a lot more new members join up recently?

  • July 16, 2012 at 8:45 am

    #1513121

    honza.mf (7/16/2012)

    rhythmk (7/16/2012)

    It is upto you if you want to learn you can use in such cases where it is hard to count the characters (exactly 30 in b option) otherwise one can directly run the query in SSMS and check the output.

    But I always use honesty is best policy to learn and test.:-)

    I agree that running of a different query is honest. But I prefer questions where no tools other than brain and eyes are needed.

    For example the length of a literal as '1234567890123456789012345678901' can be counted quite quickly.

    Could you imagine the uproar it would cause here if someone asked this question with that string and left the 2nd '7' out of there, or something to that effect?

  • July 16, 2012 at 9:16 am

    #1513143

    good question - cheers

  • July 16, 2012 at 9:56 am

    #1513174

    An easy one to start my week.

    I learned something: I laboriously counted characters on the page instead of simply copying them to Notepad. 😉

  • July 16, 2012 at 11:07 am

    #1513216

    thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 16, 2012 at 12:28 pm

    #1513252

    roryp 96873 (7/16/2012)

    honza.mf (7/16/2012)

    rhythmk (7/16/2012)

    It is upto you if you want to learn you can use in such cases where it is hard to count the characters (exactly 30 in b option) otherwise one can directly run the query in SSMS and check the output.

    But I always use honesty is best policy to learn and test.:-)

    I agree that running of a different query is honest. But I prefer questions where no tools other than brain and eyes are needed.

    For example the length of a literal as '1234567890123456789012345678901' can be counted quite quickly.

    Could you imagine the uproar it would cause here if someone asked this question with that string and left the 2nd '7' out of there, or something to that effect?

    Yes, of course :hehe:


    See, understand, learn, try, use efficient
    © Dr.Plch

  • July 16, 2012 at 1:09 pm

    #1513265

    Thanks for the question. Basic thing but I did not paid attention to detail, so -1

    Regards,

    Iulian

  • July 16, 2012 at 1:31 pm

    #1513281

    AAAAAAAHHHHHHHHH!!!!

    I knew the right answer, I thought I selected the right answer, it turns out I clicked the wrong answer!!!

    AAAAAAAAHHHHHHHHHH!!!

    Ah well... one point lost that I shouldn't have except I was being too lazy.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • July 16, 2012 at 1:56 pm

    #1513297

    Thank you for the easy, back-to-basics question.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • July 16, 2012 at 2:16 pm

    #1513309

    mtassin (7/16/2012)

    AAAAAAAHHHHHHHHH!!!!

    I knew the right answer, I thought I selected the right answer, it turns out I clicked the wrong answer!!!

    AAAAAAAAHHHHHHHHHH!!!

    Ah well... one point lost that I shouldn't have except I was being too lazy.

    Have a cup of coffee before you click. Works for me!

  • July 16, 2012 at 9:46 pm

    #1513375

    Easy one...

    Thanks

  • July 16, 2012 at 9:50 pm

    #1513377

    Thanks for the easy question. I realized only after submitting the question I have to count characters. So -1.

  • July 17, 2012 at 12:42 am

    #1513411

    Good one,thank you.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 15 posts - 16 through 30 (of 44 total)

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