Viewing 15 posts - 76 through 90 (of 110 total)
There's always value in understanding the exceptions.
The young man knows the rules, but the old man knows the exceptions. ~Oliver Wendell Holmes Sr.
March 16, 2011 at 11:40 am
Good question. Please don't hesitate to submit more. I speak for the 62% who read the question as you intended and answered correctly. Our knowledge was reinforced....
March 9, 2011 at 2:58 pm
I found SanDroid's history lesson very helpful. Thanks for adding it to the discussion.
January 25, 2011 at 10:52 am
I liked the question. I don't mind 'distractions' in the QOTD because I think that mirrors real life.
But, I would have loved to see this as three...
January 4, 2011 at 11:25 am
jts_2003 (12/30/2010)
Nice Question - it's worth understanding this before you write UPDATE statements that you would expect to work...
Definitely worthwhile. I did not know an update would work that...
December 30, 2010 at 7:01 am
mtassin (12/21/2010)
Always use the top with an ORDER BY clause!
I got the question correct, but this is the last sentance of the answer's explanation.
Why?
Why should I always use TOP...
December 27, 2010 at 7:53 pm
fourdoorvette (12/27/2010)
O.K gentlemen, how does one explain this??USE AdventureWorks
GO
DECLARE @MYDATE DATETIME2
SET @MYDATE = '1752-09-09'
PRINT @MYDATE
ANSWER
1752-09-09 00:00:00.0000000
No Error???
I am not a gentleman but I will point out that the...
December 27, 2010 at 2:24 pm
Sourav-657741 (12/27/2010)
I guessed Option:1.SSMS QA says: 1752-09-09 00:00:00.0000000
Not sure, why the correct answer is :: Option No: 3
Correct answer is #2.
December 27, 2010 at 2:19 pm
vk-kirov (12/27/2010)
I wonder how many records in one's database containing year 1752 😀
As a matter of fact, we have several hundred homes in our database that were built during the...
December 27, 2010 at 2:16 pm
QOTD doesn't get any better than this! It's obvious you paid a lot of attention to detail when you were writing it. And, you required us to pay...
December 13, 2010 at 8:31 am
I learned a lot from this QOTD. Count me as someone else who didn't know there was such a thing as conditional order by.
I can see the...
November 17, 2010 at 7:41 am
SanDroid (11/12/2010)
...true NULL is a lack of anything at all.However, SQL server has to use something to maintain that the feild...so it uses an int.
That's my guess, too....
November 12, 2010 at 8:12 am
Doh! Looks like I need to wake up a bit more, too. Careless cut and paste.
October 21, 2010 at 7:29 am
Truncate does not fail for me...?
CREATE TABLE [dbo].[CustomerMaster](
[CustomerId] [int] IDENTITY(1,1) NOT NULL,
[CustomerCode] [varchar](30),
[CustomerName] [varchar](200),
[CreatedDate] [datetime],
[ContactNo] [varchar](20)
CONSTRAINT [PK_CustomerId] PRIMARY KEY CLUSTERED
(
[CustomerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY...
October 21, 2010 at 7:22 am
Viewing 15 posts - 76 through 90 (of 110 total)