Viewing 15 posts - 6,991 through 7,005 (of 9,399 total)
Lynn Pettis (11/14/2014)
Jason-299789 (11/14/2014)
I don't disagree, and as Lynn states maybe if MS enforced it so that code wouldn't compile without the use of the statement terminators, like they do...
November 14, 2014 at 10:30 am
Stuart Davies (11/14/2014)
Ed Wagner (11/14/2014)
FridayCrunchie
Texture
November 14, 2014 at 6:42 am
GilaMonster (11/14/2014)
Jason-299789 (11/14/2014)
The problem is that 90% of developers don't use the ';' on every line of code
.Well they should start doing so .The trend over the last few versions...
November 14, 2014 at 6:06 am
Makes me wonder what else is in the real cost that's missing from the post. The successful execution in one session and not the other has me puzzled (as...
November 14, 2014 at 5:55 am
I don't track any data about my bucket list and keep track of the list in my head with what I have left. The cool ones:
Marriages: 1 at 18...
November 14, 2014 at 5:41 am
Like others, I would assume the full product unless express edition was explicitly stated. At least the answers didn't include the minimum 1 GB and recommended 4 GB. ...
November 14, 2014 at 5:30 am
I thought this was a good question and like Tom pointed out, not a lot of people are familiar with them. It does come with some overhead, but it's...
November 14, 2014 at 5:27 am
Grant Fritchey (11/13/2014)
November 13, 2014 at 5:14 am
Drop the [] where the name would go.
CREATE TABLE [dbo].[#ShipTo](
[Ship_to_Num] [int] NOT NULL,
[Country_key] [nvarchar](3) NULL,
PRIMARY KEY CLUSTERED
(
[ship_to_Num] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS =...
November 12, 2014 at 1:46 pm
Sean Lange (11/12/2014)
Holy spam running crazy!!! The spam filter seems to have been turned off again. Whatever is being done to prevent spam is not working.
Yeah, did you see it...
November 12, 2014 at 1:05 pm
hjp (11/12/2014)
SQLRNNR (11/12/2014)
Impossible. There are multiple correct answers.JK
Ducks and runs - snigger.:-D:-D:-D:hehe:
Like... what?? If you don't present your case and argue why you think so, then why bother writing...
November 12, 2014 at 8:59 am
marcia.j.wilson (11/12/2014)
Ed Wagner (11/12/2014)
h.tobisch (11/12/2014)
It should not be a programmer's responsibility (alas it sometimes is) to figure out what some quirky piece of code might be doing,
but...
November 12, 2014 at 8:43 am
spaghettidba (11/12/2014)
Looks standard SQL-92 to me.Please note that the UNION could be a cheaper UNION ALL (doesn't perform a DISTINCT).
I agree, except that your EXISTS needs an S on the...
November 12, 2014 at 8:24 am
h.tobisch (11/12/2014)
It should not be a programmer's responsibility (alas it sometimes is) to figure out what some quirky piece of code might be doing,
but to express his...
November 12, 2014 at 7:24 am
Viewing 15 posts - 6,991 through 7,005 (of 9,399 total)