Forum Replies Created

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

  • RE: Distinct

    Lokesh Vij (5/6/2013)

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

    +1 nice question....

    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...

    May 3, 2013 at 5:36 am

    #1612154

  • RE: Table Variable

    nice question...

    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...

    April 23, 2013 at 6:16 am

    #1609014

  • RE: Row Constructor

    nice question...

    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...

    April 16, 2013 at 5:40 am

    #1606777

  • RE: SQL JOINS

    nice question... very simple....

    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...

    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...

    April 10, 2013 at 7:13 am

    #1605207

  • RE: Identity Columns

    SQLRNNR (4/9/2013)

    good question

    +1

    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...

    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...

    April 4, 2013 at 8:52 am

    #1603592

  • RE: LEFT JOIN

    nice question....

    manik

    Go Fast As Possible

    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...

    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...

    April 2, 2013 at 6:22 am

    #1602769

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