Forum Replies Created

Viewing 15 posts - 1 through 15 (of 187 total)

  • RE: It's Not All About The Keys

    SQLRNNR (4/15/2014)


    Dineshbabu (4/15/2014)


    Hi Andy,

    Its good try. But I will not agree with your answer.

    I will go for Query used to check the data is not correct.

    Because there can be...

  • RE: It's Not All About The Keys

    Hi Andy,

    Its good try. But I will not agree with your answer.

    I will go for Query used to check the data is not correct.

    Because there can be cases where...

  • RE: Sales puzzle

    kaspencer (8/14/2013)


    I have worked with SQL Server on and off for many years, but I don't think I recall ever seeing "ORDER BY [number]" as it appears in this question.

    Could...

  • RE: The US Holiday

    Primo Dang (7/4/2013)


    Lokesh Vij (7/3/2013)


    I thought this to be the easiest Qotd ever attempted. Wondering why so many wrong attempts!!

    Correct answers: 48% (11)

    Incorrect answers: 52% (12)

    Total attempts: 23

    I think a lot of people might...

  • RE: How does SQL pronounce SQL?

    Good question, Learned two new functions. But i don't know where can I use it.

  • RE: How does SQL pronounce SQL?

    -

  • RE: INTO Identities

    L' Eomot Inversé (5/24/2013)


    Dineshbabu (5/24/2013)


    So finally From which version of SQL server, Identity property is copied into new table eventhough if the query has a GROUP BY clause.

    Then next question...

  • RE: SELECT INTO FILESTREAM

    I don't have idea about filestream but i'm sure other than IDENTITY property no other attributes will be copied to new table. So i guessed it should be varchar(max) but...

  • RE: Use of Key Column

    Good question .. But explanation is slightly wrong.

    Table is not created because varchar(MAX) is not allowed type for use as a key column in an index. This doesn't mean you...

  • RE: Temp Tables

    Christian Buettner-167247 (5/27/2013)


    Good question, but the answer is wrong.

    SQL Server evaluates object references during parse time. Flow-control logic is not applied at this stage.

    This is not true. If you change...

  • RE: INTO Identities

    So finally From which version of SQL server, Identity property is copied into new table eventhough if the query has a GROUP BY clause.

    Then next question is it the intended...

  • RE: Temp Tables

    Good question. Just yesterday Hugo is explaining about parsing in another QotD.

  • RE: INSERT

    Thank you very much Hugo for spending your valuable time to make me understand.

  • RE: INSERT

    Hugo Kornelis (5/23/2013)


    Sure. It's here: http://www.sqlservercentral.com/questions/T-SQL/98942/[/url].

    First run the part where the two tables are created (the CREATE TABLE and the SELECT INTO). You may have to change upper- and lower-case,...

  • RE: INSERT

    Hugo Kornelis (5/23/2013)


    Dineshbabu (5/23/2013)


    Hugo,

    In this scenario, eventhough if we run both insert statements as single batch, first statement will be executed successfully and we will get error only on...

Viewing 15 posts - 1 through 15 (of 187 total)