Viewing 15 posts - 91 through 105 (of 143 total)
OCTom (4/17/2013)
hakim.ali (4/17/2013)
May 13, 2013 at 12:47 am
kapil_kk (4/17/2013)
New thing to learn... 🙂
Whilst I agree, I wonder if anyone has ever used this idea in a real piece of coding? The values are hard-coded and that's...
May 13, 2013 at 12:41 am
Hugo Kornelis (4/4/2013)
...When I saw the question in the newsletter, I expected the answer options to be phrased in terms of the supplied data.
...
I agree. It reduces the change...
April 10, 2013 at 4:45 am
Revenant (4/2/2013)
I like to terminate each statement with a semicolon and I made this mistake years ago: "Experience is an euphemism for our past mistakes."Thanks, Venkat!
Surely our past mistakes are...
April 4, 2013 at 8:30 am
Danny Ocean (3/31/2013)
Easy question 😀 and lots of points.:w00t:
What he said.
April 3, 2013 at 2:40 am
L' Eomot Inversé (3/26/2013)
Hugo Kornelis (3/26/2013)
March 28, 2013 at 8:15 am
dwain.c (3/26/2013)
Second, I'd like to apologize for not saying the above sooner but I've...
March 28, 2013 at 7:55 am
dwain.c (3/24/2013)
kapil_kk (3/24/2013)
This wil also give error :DROP FUNCTION dbo.Test DROP TYPE dbo.MyTable GO
as GO is present at the same line where it should not be....
Alas I got wrong :w00t:
I'll...
March 28, 2013 at 7:53 am
Hi Hugo,
Thanks for your reply.
By 'why bother' I guess you're meaning why bother using triggers instead of cascade delete? Because the 4GL in which we write the application can't handle...
March 21, 2013 at 3:41 am
This is a question about table design raised because of this QoD.
Re this part of the question:
"CREATE TABLE [dbo].[OrderDetail](
[OrderDetailID] [int] NOT NULL,
[OrderID] [int] NULL,
CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED
([OrderDetailID] ASC))"
why...
March 21, 2013 at 3:14 am
Lokesh Vij (3/20/2013)
db4breakfast (3/20/2013)
I never use cascade delete on a production db. It seem to be safer by allowing users mark order as "error" instead.
+1
same here. i feel it is...
March 21, 2013 at 3:09 am
peter.row (3/20/2013)
Basic question designed to seem like a trick?This applies equally to SQL Server 2005 and 2008 not just 2008R2 and 2012.
Might 2008R2 and 2012 have been specified because those...
March 21, 2013 at 3:07 am
I've been catching up with unanswered DATETIME... questions of late so this was an easy one.
March 20, 2013 at 7:06 am
BrainDonor (1/24/2013)
The true answer should be "Either is a candidate at this point, due to insufficient information".
That goes along with my thoughts. An answer of 'Either may be appropriate'...
February 13, 2013 at 2:51 am
Thanks for everyone's assistance.
I don't think -d in sqlcmd will work for us as this expects the db_name whereas we are providing the data source name to -D in osql;...
December 11, 2012 at 3:22 am
Viewing 15 posts - 91 through 105 (of 143 total)