Viewing 15 posts - 1,816 through 1,830 (of 3,348 total)
marlon.seton (3/21/2013)
Re this part of the question:
"CREATE TABLE [dbo].[OrderDetail](
[OrderDetailID] [int] NOT NULL,
[OrderID] [int] NULL,
CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED
([OrderDetailID]...
March 21, 2013 at 3:48 am
marlon.seton (3/21/2013)
We use triggers to delete the child records when a parent record is deleted. Is that generally considered a bad thing to do?
Bad? I would not say so...
March 21, 2013 at 3:38 am
Toreador (3/21/2013)
Using cascade delete. If the business rule says that is the appropriate behaviour, then why avoid using inbuilt functionality that achieves exactly what you need?
One possible reason is that...
March 21, 2013 at 3:34 am
David Burrows (3/19/2013)
March 19, 2013 at 5:06 pm
demonfox (3/19/2013)
http://www.loc.gov/standards/iso639-2/php/code_list.php
here is a discussion reference and an included further references .. I think, this might the standard followed by ms in sql...
March 19, 2013 at 4:44 pm
David Burrows (3/19/2013)
Shame they did not extend DATEADD to include a time option 🙁
They didn't need to. DATEADD has always supported time options.
March 19, 2013 at 8:37 am
(Bob Brown) (3/19/2013)
Hugo Kornelis (3/19/2013)
Can anyone fill me in on the missing details?
I don't know if this is any help but it is what I used to answer...
March 19, 2013 at 7:25 am
L' Eomot Inversé (3/19/2013)
Hugo Kornelis (3/19/2013)
March 19, 2013 at 7:21 am
L' Eomot Inversé (3/19/2013)
March 19, 2013 at 6:37 am
Great question, Steve!!
I had a strong hunch, but I wanted to know for sure so I tried to find a list of three-letter language codes. I couldn't - so I...
March 19, 2013 at 3:29 am
Richard Warr (3/14/2013)
What do I have that is different (I'm in the UK if that helps)?
Locale settings.
Contrary to popular belief, yyyy-mm-dd hh:mm:ss and yyyy-mm-dd are NOT a guaranteed safe date...
March 14, 2013 at 4:32 am
Toreador (3/14/2013)
sknox (3/13/2013)
It then goes on to provide several data type examples, including a lot of "date" constants which are actually all varchar constants.
Blimey. That really is quite special. Presumably...
March 14, 2013 at 3:33 am
The idea of this question is nice, but the execution is poor (i.e. "correct" answer is not correct) and the explanation is simply incorrect.
As others have said, the chance is...
March 12, 2013 at 2:01 am
Dave62 (3/11/2013)
I'm thinking about including a question like this in an interviewing process.
I don't agree. I happened to know this one because I was already using SQL Server at the...
March 11, 2013 at 7:57 am
Lack of proper reading skills helped me get this question right. I thought options 3 and 5 were about allowing or not allowing ORDER BY withhout TOP on first reading....
March 11, 2013 at 5:20 am
Viewing 15 posts - 1,816 through 1,830 (of 3,348 total)