I saw something new today. Wondered if anyone else had seen it, and if it was T-SQL specific or ISO. BoL entry for SELECT does not suggest it is valid, but it is. Whaddaya reckon the result will be? (tested in SQL 2005 & 2008)
, (SELECT schema_id)
, (SELECT TOP 937 type_desc)
without changing the result. It returns 92 records on my test system.
Oh I'm not claiming an advantage.
Think further! You must have heard of The Obfuscated C and Perl Contests. Now we can have our own Obfuscated MS-SQL Contests ® (OMSC) too! Just think of all the advantages it will bring to be able to write code only at most 2 other people on Earth are able to understand. And then imagine the benefits of one of your developers in your team sharpening his/her OMSC®-skills on production software on a daily base!
Last edited by Wim; 02-18-11 at 12:19.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2. Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages