Viewing 15 posts - 16 through 30 (of 212 total)
That was an easy one, thanks! You could also solve this query with CONCAT. 🙂
January 25, 2017 at 2:28 am
It's a classic implicit conversion issue. SQL Server will never convert a "bigger" datatype to a smaller.
July 11, 2016 at 6:49 am
Well it's still possible to write the alias in 12 different ways in SQL2014 (deprecated or not) 🙂
SELECT object_id AS test
FROM sys.columns AS mt;
SELECT object_id AS 'test'
FROM sys.columns...
September 6, 2015 at 5:50 am
SQL Guy 1 (10/7/2014)
From Text field I can...
November 4, 2014 at 9:26 am
Interesting SQL server question! I learned something new today. 🙂
November 2, 2014 at 6:00 pm
Interesting question! Never heard of it and got It wrong, but I learned something new. Thank you!
October 27, 2014 at 1:21 am
TomThomson (10/23/2014)
Amusing question; the use of RAND is an interesting distraction for a question that is really about UNION ALL and nothing else.
I agree! It would have been UNION instead...
October 26, 2014 at 5:26 pm
Thanks for the easy one. 🙂 I've used template files a lot and I love them.
October 26, 2014 at 5:19 pm
Mighty (10/16/2014)
0 points out of 2. Will try to select an incorrect answer tomorrow to see if I get a point. 😛
Excellent idea! 🙂
October 16, 2014 at 3:02 am
Vimal Lohani (10/15/2014)
twin.devil (10/15/2014)
Comments posted to this topic are about the item <A HREF="/questions/unpivot/117130/">Unpivot</A>
HAHA,
Still wrong answer
admin has not tested it.
Answer should be two rows.
OrderIDProductNameProductQty
1 ...
October 16, 2014 at 2:08 am
Toreador (10/15/2014)
paul.knibbs (10/15/2014)
I mean, the error about incorrect syntax near "FROM" isn't one of the available answer options, so it should be pretty obvious that's not what was intended.
It would...
October 15, 2014 at 2:59 am
That was an easy question. 🙂 Thank you for that point.
October 6, 2014 at 1:11 am
Ed Wagner (10/3/2014)
SqlMel (10/3/2014)
But I must say that I do not use this feature in my coding.
I haven't either. I'd use TOP myself, but this is another nice tool...
October 3, 2014 at 7:43 am
Sean Pearce (10/1/2014)
Roland C (10/1/2014)
Another badly redacted question ! It gets a little boring :doze:You could always submit your own question.
I agree with you. I Think it's hard to create...
October 2, 2014 at 1:19 am
Eirikur Eiriksson (10/1/2014)
Slightly off topic, prefer using RAISERROR to PRINT for progress reporting on long running scripts as it is almost instant and the printf...
October 2, 2014 at 1:12 am
Viewing 15 posts - 16 through 30 (of 212 total)