Forum Replies Created

Viewing 15 posts - 76 through 90 (of 145 total)

  • RE: Distinct

    Lokesh Vij (5/6/2013)

    Thanks for the easy one Vinay, after tricky Qotd yesterday 🙂

    +1 nice question....

    Manik
    You cannot get to the top by sitting on your bottom.

    May 8, 2013 at 7:00 am

    #1613313

  • RE: Identity Insert

    Raghavendra Mudugal (5/3/2013)

    Toreador (5/3/2013)

    Danny Ocean (5/2/2013)

    Most of people don't know about it because it's not in use in any real scenario.

    Sure it is, if the table contains other columns, all...

    Manik
    You cannot get to the top by sitting on your bottom.

    May 3, 2013 at 5:36 am

    #1612154

  • RE: Table Variable

    nice question...

    Manik
    You cannot get to the top by sitting on your bottom.

    May 2, 2013 at 8:32 am

    #1611906

  • RE: Sum and Count

    WWDMark (4/18/2013)

    Danny Ocean (4/17/2013)

    kapil_kk (4/17/2013)

    Nice question... learn something new today.. 🙂

    But can anyone plz explain me about the SUM part which is returning 12, I am not clear with this...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 23, 2013 at 6:16 am

    #1609014

  • RE: Row Constructor

    nice question...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 17, 2013 at 5:44 am

    #1607196

  • RE: COUNT() Function

    kapil_kk (4/15/2013)

    For the last query:

    select COUNT(convert(int,NULL)) from #temp

    It will return 0 because when you execute the query:

    SELECT CONVERT(int,NULL) it will return NULL and as the return type of COUNT is...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 16, 2013 at 5:40 am

    #1606777

  • RE: SQL JOINS

    nice question... very simple....

    Manik
    You cannot get to the top by sitting on your bottom.

    April 15, 2013 at 2:09 am

    #1606372

  • RE: DateTime data types

    Primo Dang (4/11/2013)

    Got it right by elimination. There is no way a NULL value would be converted to an actual date (as far as I know, at least), so that...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 12, 2013 at 1:57 am

    #1605876

  • RE: TRIGGERS

    Danny Ocean (4/9/2013)

    Hugo Kornelis (4/9/2013)

    Danny Ocean (4/9/2013)

    BUT statement 6 (ID 4 & 5) execute successfully and inserted two rows in table. In this we are using UNION ALL.

    How it's possible...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 10, 2013 at 7:13 am

    #1605207

  • RE: Identity Columns

    SQLRNNR (4/9/2013)

    good question

    +1

    Manik
    You cannot get to the top by sitting on your bottom.

    April 10, 2013 at 6:58 am

    #1605201

  • RE: ISNUMERIC

    kapil_kk (4/8/2013)

    Hugo Kornelis (4/8/2013)

    kapil_kk (4/8/2013)

    For the first part I understand the behavior but am still confused with the SELECT ISNUMERIC('.+') -- Returns 0 behavior 🙁

    The . actually represents 0.0, with...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 10, 2013 at 6:39 am

    #1605192

  • RE: Passing Tables as Parameters

    Dineshbabu (4/1/2013)

    Nice question.

    +1

    Manik

    Go Fast As Possible...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 4, 2013 at 8:52 am

    #1603592

  • RE: LEFT JOIN

    nice question....

    manik

    Go Fast As Possible

    Manik
    You cannot get to the top by sitting on your bottom.

    April 4, 2013 at 8:42 am

    #1603587

  • RE: LEN()

    Hugo Kornelis (4/2/2013)

    Dineshbabu (4/1/2013)

    Thanks Hugo,

    I have one more doubt, will ANSI_PADDING set option affects the datastorage?

    No and yes.

    No, because the working of LEN and DATA_LENGTH are not affected by this...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 2, 2013 at 6:30 am

    #1602772

  • RE: LEN()

    Hugo Kornelis (4/1/2013)

    Dineshbabu (4/1/2013)

    If somebody explains the difference b/w Datalength() & Len() in this thread will be useful.

    Datalength returns the amount of bytes that would be used on disk for...

    Manik
    You cannot get to the top by sitting on your bottom.

    April 2, 2013 at 6:22 am

    #1602769

Viewing 15 posts - 76 through 90 (of 145 total)