2015-07-30
1,278 reads
2015-07-30
1,278 reads
2015-07-16
1,506 reads
2015-07-10
1,251 reads
Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.
2016-10-28 (first published: 2015-06-22)
14,362 reads
2015-06-19
1,441 reads
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
By Steve Jones
One of the things that I think is neat is that Redgate Monitor helps...
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
AOL Desktop Gold Download+1 (858) 333 4611 : A Step-by-Step Guide AOL Desktop Gold...
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Comments posted to this topic are about the item Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers