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

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

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

Primo Dang (7/4/2013)

---

I think a lot of people might...

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

-

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

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

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

Christian Buettner-167247 (5/27/2013)

---

Good question, but the answer is wrong.

This is not true. If you change...

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

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

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

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

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