Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,552 reads
Articles
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,636 reads
Computer Problem Report Form
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
2001-04-25
3,458 reads
Keeping Your Developers Under Control
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,798 reads
Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
6,961 reads
Stuff Computer Support People Love
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
2001-04-24
3,675 reads
Using InterDev's Toolbox
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
2001-04-24
3,066 reads
Introduction to DSN's
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
2001-04-23
8,528 reads
Analysis Services Enhancements
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
2001-04-22
4,385 reads
Automatically Gathering Server Information Part 4
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-22
5,913 reads
Blogs
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
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