我查过SQL Reference了,这应该是可行的。。

来源: 2006-05-04 21:42:09 [旧帖] [给我悄悄话] 本文已被阅读:

"In Transact-SQL, a subquery can appear almost anywhere an expression can be used, if it returns a single value."