Reliably Drop A Database With CLR Stored Procedure
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...
2014-01-22 (first published: 2014-01-20)
2,325 reads
Jeffrey Yao
Reliably Drop A Database With CLR Stored Procedure
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...
2014-01-20
411 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
1,101 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
404 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
724 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
382 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
1,279 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
341 reads
Database Administration KPIs – 2/2
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-10 (first published: 2013-05-04)
5,190 reads
Database Administration KPIs – 2/2
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-04
911 reads
Blogs
T-SQL Tuesday #181: A Technology Present
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
Trace Flag 3625 Follow Up
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
Peer review SQL Central articles
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
Why Would You Do That?
Comments posted to this topic are about the item Why Would You Do That?
Question of the Day
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