Viewing 13 posts - 16 through 28 (of 28 total)
Posted incompletely, see below for my comments
December 13, 2011 at 1:27 am
Koen Verbeeck (12/7/2011) But not in production 😀
What could possibly go wrong with running code from SQL Server Central on the production server?
........ oh yes, I remember .......
.... it can...
December 8, 2011 at 1:58 am
Iulian -207023 (11/10/2011)
Any way I thinkORDER BY constantshould be innofensive. Why such a severe message?Regards,
Iulian
Iulian,
ORDER BY 2
does not mean the same as
ORDER BY constant
, it means...
November 10, 2011 at 7:25 am
Koen Verbeeck (11/8/2011)
It is always a good idea to run scripts from the internet on the master database of the production server 😀
Lesson Learnt. It won't be happening again.:blush:
November 8, 2011 at 1:55 am
WORD OF WARNING,
Having guessed the right answer I then decided to run it on our SQL 2005 (production) server.
After restarting the service this line was found in the log.
11/08/2011 08:13:34,spid80,Unknown,SqlDumpExceptionHandler:...
November 8, 2011 at 1:26 am
Stewart,
I agree that this does not change the aim of the question. I got the question wrong due to not really reading the question correctly after getting hung up...
November 3, 2011 at 3:13 am
When running this in SQL2005 I get the following response (after answering the question)
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137,...
November 3, 2011 at 2:35 am
Carlo Romagnano (12/20/2010)
Please, read carefully the question: it asks how many rows are in the results and what is the value of column "d" on the last row.
:blush: That will...
December 20, 2010 at 3:19 am
da-zero (12/20/2010)
Your output has 7 rows and the column d contains "three" for the 7th row, so it should be answer D.
But Answer D is
7 rows where column d...
December 20, 2010 at 2:35 am
I have to disagree with the answer. I ran the code on SQL server 2005 and got the following output:
abcd
4join14join2
4join14join2
2join32one
2join32one
1oneNULLNULL
NULLNULLNULLtwo
NULLNULLNULLthree
As I had worked out the same output before running...
December 20, 2010 at 2:17 am
An interesting question, but am I missing something here? When would you use coalesce entirely with untyped values?
If I were using coalesce it would be to test column values or...
November 12, 2010 at 1:30 am
messineo,
If you have multiple columns that you want to deduplicate on you will need to include all of them in whichever method you use.
Here is some sample code using each...
July 27, 2010 at 4:46 am
I was interested to see what the difference in performance between these queries as I would always have used Row_Number with a partition before.
On the Northwind database (SQL 2005) I...
July 27, 2010 at 2:31 am
Viewing 13 posts - 16 through 28 (of 28 total)