Viewing 15 posts - 91 through 105 (of 105 total)
nenad-zivkovic (7/15/2013)
So...
July 15, 2013 at 5:06 am
Danny Ocean (7/2/2013)
raulggonzalez (7/2/2013)
Danny Ocean (7/1/2013)Thanks raulggonzalez 🙂
You're welcome!
but please note that the script would give you correct results only when freq_interval = 8
http://msdn.microsoft.com/en-us/library/ms178644.aspx
Cheers
July 2, 2013 at 9:18 am
Danny Ocean (7/1/2013)
Good question. But i never feel to use "Bitwise AND" (&) in real working scenario. It will good, if anyone come with some real working example. 🙂
Hi, another...
July 2, 2013 at 4:41 am
Thanks for the nice question with plenty of knowledge involved, but I've got it just because none of the above made sense for me, and the explanation is not 100%...
June 12, 2013 at 5:18 am
Good stuff,
but I'm afraid you missed something which can be important and it's the NULLability of the columns.
If you have a column which is text NOT NULL, your script...
May 14, 2013 at 4:18 am
Danny Ocean (5/2/2013)
May 3, 2013 at 6:18 am
Really good question, tricky and nice.
Obviously the default value for IDENTITY_INSERT is OFF, only by changing it to ON, you wouldn't be able to insert any of the rows as...
April 24, 2013 at 4:56 am
Now seriously...
what's the point of this QotD? It's not testing any knowledge of how CHOOSE works.
If the aim of this is to push you to install SQL 2012 and AW...
January 29, 2013 at 8:38 am
I don't see what this QotD is trying to test... It's not about how CHOOSE works but what data you have in a table that is not represented on the...
January 28, 2013 at 2:34 am
negative questions make true to be false and vice versa... should've double read an easy question :Whistling:
January 16, 2013 at 5:49 am
is it me the only one who finds all answers wrong as there's a missing parenthesis in all of them??
depends on where you place the missing one in 'select 2'...
January 1, 2013 at 7:45 am
I completely agree with many other peers.
My first answer was that none of them could be returned by that query (4 cols in select statement, only 3 values per row.....
June 26, 2012 at 7:40 am
The explanation I see is that on answers 1,3,4,5,6 implicit data types conversion happens because of mixing INT and CHAR types.
On the answer 2, we just try to multiply 2...
February 29, 2012 at 1:37 am
I absolutely agree on that!
Elliott Whitlow (2/21/2012)
handkot (2/21/2012)
select @@VERSIONMicrosoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation ...
February 22, 2012 at 1:16 am
Viewing 15 posts - 91 through 105 (of 105 total)