Viewing 15 posts - 1,516 through 1,530 (of 7,484 total)
The old notation =* was used for a right outer join, not for a left outer join (that was *=); maybe that's the cause of your difficulties?
August 2, 2015 at 7:28 pm
It depends on two things: 1. the frequency of inserts to the table, and 2. whether queries typically access several adjacent rows in the ordering you choose to place on...
August 2, 2015 at 7:19 pm
Ed Wagner (7/31/2015)
Then again, getting to the heart of the security matter...my "sa" account is disabled as it should be.
I prefer to have no SA account - no SQL logins,...
August 1, 2015 at 7:24 pm
Jeff Moden (7/31/2015)
jghali (7/31/2015)
Note to self: Always look at the date before posting!!! :hehe:
Did you ever create...
August 1, 2015 at 7:10 pm
whereisSQL? (7/31/2015)
Eirikur Eiriksson (7/31/2015)
Ray K (7/31/2015)
SQLRNNR (7/31/2015)
eccentricDBA (7/31/2015)
Pawtucket Patriot Ale
Nantucket Nimble Nail
Sam Adams Summer Ale
Rhyming attempts fail
Same
Game
August 1, 2015 at 6:26 pm
DonlSimpson (7/30/2015)
Luis Cazares (7/30/2015)
Ray K (7/30/2015)
Eirikur Eiriksson (7/30/2015)
Ed Wagner (7/30/2015)
VacationWagon Queen
Drama queen
Dancing Queen
ABBA
Waterloo
July 30, 2015 at 4:34 pm
Interesting question. Works in current versions but shows bad practise.
Every SQL Server version I have known would do this, but in theory the value returned could be any row...
July 29, 2015 at 9:51 am
Iwas Bornready (7/28/2015)
robert.sterbal 56890 (7/27/2015)
I always wish they would publish the previous survey and the actual results as well as the current one.That's actually a really good idea.
No, for...
July 28, 2015 at 4:33 pm
Brandie Tarvin (7/27/2015)
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught at that...
July 27, 2015 at 8:08 pm
SQLRNNR (7/27/2015)
Revenant (7/27/2015)
Ray K (7/27/2015)
DonlSimpson (7/26/2015)
TomThomson (7/25/2015)
SQLRNNR (7/25/2015)
outre-merultramar
Montreal
Expos
Nationals
GNATS
Bites
July 27, 2015 at 7:42 pm
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught at that one in France...
July 26, 2015 at 1:02 pm
SQLRNNR (7/25/2015)
TomThomson (7/25/2015)
What...
July 26, 2015 at 12:52 pm
You need to deal with a NULL introduced by the left join - it will produce NULL when there is no appropriate row in the RH table, but the results...
July 25, 2015 at 4:25 pm
You certainly can have SSMS with SQLS 2008 Express, but the way I did it was to install "SQL Server Express with Tools" rather than the server and the tools...
July 25, 2015 at 3:50 pm
Actually none of the options is correct. The third is just plain wrong and the others each omit the first column (name) from the returned row.
What is actually...
July 25, 2015 at 3:35 pm
Viewing 15 posts - 1,516 through 1,530 (of 7,484 total)