Question

sql server2000中为何不能用except ,请各位高手指点！！！

Answer 1

SqlServer2000 不是完全支持92标准。所以大家都疯狂转到08呀。
---------------------------------------------------------------------------------
如下是SQL92 查询语法，其中是有except 定义的，你在看看2000的查询语法。
SELECT query
Description: Retrieve rows from a table or view
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
expression [ <![AS]> name ] [,...]
[ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ]
[ FROM {table | (select query)} [ alias ] [,...] ]
[ {{LEFT | RIGHT} [OUTER] | NATURAL |[FULL] OUTER} JOIN table alias
{ON condition | USING(col1,col2,...)} ]
[ WHERE {condition | EXISTS (correlated subquery)} ]
[ GROUP BY column [,...] ]
[ HAVING condition [,...] ]
[ { UNION [ ALL ] | INTERSECT | EXCEPT | MINUS } select ]
[ ORDER BY {column | int} [ ASC | DESC | USING operator ] [,...] ]
[ FOR UPDATE [ OF class_name [,...] ] ]
LIMIT { count | ALL } [ { OFFSET | ,} start ]
----------------------
如下是2000语法：
Syntax

SELECT statement ::=
< query_expression >
[ ORDER BY { order_by_expression | column_position [ ASC | DESC ] }
[ ,...n ] ]
[ COMPUTE
{ { AVG | COUNT | MAX | MIN | SUM } ( expression ) } [ ,...n ]
[ BY expression [ ,...n ] ]
]
[ FOR { BROWSE | XML { RAW | AUTO | EXPLICIT }
[ , XMLDATA ]
[ , ELEMENTS ]
[ , BINARY base64 ]
}
]
[ OPTION ( < query_hint > [ ,...n ]) ]

< query expression > ::=
{ < query specification > | ( < query expression > ) }
[ UNION [ ALL ] < query specification | ( < query expression > ) [...n ] ]

< query specification > ::=
SELECT [ ALL | DISTINCT ]
[ { TOP integer | TOP integer PERCENT } [ WITH TIES ] ]
< select_list >
[ INTO new_table ]
[ FROM { < table_source > } [ ,...n ] ]
[ WHERE < search_condition > ]
[ GROUP BY [ ALL ] group_by_expression [ ,...n ]
[ WITH { CUBE | ROLLUP } ]
]
[ HAVING < search_condition > ]
-----------
你对比一番就看出来了！ 2005才支持except ，至于2005是否完全支持92 还很难说。你自己看参考链接吧！

Answer 2

像用事件回滚，不用except

Answer 3

sql server 2005开始才支持except的，2000的话你只能用其它的方法来完成了。

Answer 4

except sql server 2000 好像不能用吧？ 2005好像可以用

select s# from student
WHERE sname not like '刘%'