Not to knock batch file programming (there's some really impressive stuff you can do, lots of enthusiasts out there), but if this is a windows environment wouldn't VBScript (run using...

Sorry to whine, but this question is a little disappointing - It's educational on at least two counts (grouping sets - new feature, and possible gotcha on floating point numbers),...

ah-hah, thanks John, that makes a whole lot of sense!

Hmm, getting late to this, but I'm having difficulty accepting the answer provided here. Here is the exact result I received on a SQL Server 2000 instance:

Server: Msg 245, Level...

OK, so now I'm in awe of Chris Morris too... 🙂

wow, I am in awe (assuming it works 🙂 ). I would venture a guess that this is, indeed, the most efficient solution.

One fix required here is to separate the...

Hmm, my curiousity is piqued... The solution presented is quite interesting, but I believe the purported interest in bits and bytes is a little exaggerated, as the solution is still...

ah, thanks George! I wasn't planning on investigating further after Hugo's authoritative explanation, but I was a little weirded out that the BOL (2000) documentation I was looking at mentioned...

Got it, thanks for the update!

Hmm, I'm a little confused...

I assumed the question was talking about files from any arbitrary database - but the "ALTER DATABASE ... MODIFY FILE" clause can only (if I understand...

Hi, the sample actually assumes old-style ASP (usually coded in VBScript), but the point is not the extraction of the list of databases.

Getting the list of databases using this technique...

Hmm, I guess I knew where the author was going and got the answer right, but I disagree with the premise of the question.

The asssumption that you can prevent SQL...

Fun question!

I believe it is because Parameterization requires that every replaceable value in the query have its own "Parameter" in the cached plan.

So if the IN operator allowed for auto-parameterization (it...

Hi Ramkumar,

An "auto parameterized" query is a query that SQL Server caches and reuses a query plan for anyway, even though the query itself does not have any parameters defined.

eg,...