Viewing 15 posts - 5,176 through 5,190 (of 7,484 total)
I don't agree with this answer at all. Partly because I would never dream of shipping a file with real live passwords in it, partly because I believe that...
November 15, 2011 at 12:27 pm
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...
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; --...
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...
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...
November 14, 2011 at 12:17 pm
Brandie Tarvin (11/14/2011)
November 14, 2011 at 12:10 pm
Brandie Tarvin (11/14/2011)
November 14, 2011 at 10:53 am
SanDroid (11/14/2011)
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,...
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...
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...
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...
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...
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...
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...
November 14, 2011 at 3:34 am
Viewing 15 posts - 5,176 through 5,190 (of 7,484 total)