Viewing 15 posts - 5,176 through 5,190 (of 7,483 total)
Nice question.
It made me think, briefly, because I was startled by the unnamed single column constraint. I'm so used to writing unnamed single column primary key, unique, reference, and...
Tom
November 15, 2011 at 10:14 am
Brandie Tarvin (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Guy missing 60 cpus! Don't know how to help.http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx
Did he feed them after midnight or get water on them?
SET Snark = OFF;
SET SNARK = ON; --...
Tom
November 15, 2011 at 5:43 am
I find myself somewhat confused here. I agree with Phil, and I agree with Gus; but they appear to think they disagree with each other.
And the Major...
Tom
November 14, 2011 at 6:47 pm
SQL Kiwi (11/14/2011)
No, not that one so much; the search I gave should bring up MERGE bugs on Connect like these:
Just seeing 353 hits is quite scary. I guess...
Tom
November 14, 2011 at 12:17 pm
Brandie Tarvin (11/14/2011)
Tom
November 14, 2011 at 12:10 pm
Brandie Tarvin (11/14/2011)
Tom
November 14, 2011 at 10:53 am
SanDroid (11/14/2011)
Tom
November 14, 2011 at 9:43 am
GilaMonster (11/14/2011)
What kind of error is this?
SELECT Col1, Col2, Col3 FROM TableThatDoesNotExist
It's not a syntax error, that passes syntax check successfully.
It's not a run-time error,...
Tom
November 14, 2011 at 9:24 am
Dev (11/14/2011)
but that is not standard SQL, support for that construct may be removed in future (not any time soon, though)
I was unaware of this fact. Are you...
Tom
November 14, 2011 at 9:05 am
I'm maybe retired, maybe not. I'm not prepared to work more than 16 weeks per year, which makes me at leat semi-retired, and that firm rule (plus restrictions on...
Tom
November 14, 2011 at 8:42 am
That's what I call a good editorial.
There's too much emphasis on having learnt relevant technology these days, and not enough on having learnt to think and having learnt effective learning...
Tom
November 14, 2011 at 8:26 am
martin.kerr 34088 (11/14/2011)
I am trying to do an update statement:
begin tran
update dbo.Addresses
set addresses.Address1Original = addressescapscan.Address1Original,
addresses.Address2Original = addressescapscan.Address2Original,
addresses.Address3Original = addressescapscan.Address3Original,
addresses.TownOriginal = addressescapscan.TownOriginal,
addresses.CountyOriginal = addressescapscan.CountyOriginal,
addresses.PostcodeOriginal = addressescapscan.PostcodeOriginal,
addresses.CountryOriginal = addressescapscan.CountryOriginal
join dbo.Addresses on...
Tom
November 14, 2011 at 5:23 am
Brandie Tarvin (11/14/2011)
GilaMonster (11/14/2011)
SQLRNNR (11/13/2011)
I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name.
Likewise and a waste of time when...
Tom
November 14, 2011 at 4:56 am
martin.whitton (11/14/2011)
paul s-306273 (11/14/2011)
I'd like to say I don't like these questions - but looking at the posts I appear to be in the minority!Anybody else out there with me?
I...
Tom
November 14, 2011 at 3:34 am
Dev (11/14/2011)
My ONLY argument is this.Dev (11/11/2011)
ID
---
2|4|6
It's bad design. If you have control on database schema, re-design it.
Well, yes, it's usually a good idea to normalise...
Tom
November 14, 2011 at 2:17 am
Viewing 15 posts - 5,176 through 5,190 (of 7,483 total)