exists-top.sql

来自「sql server 2000 系统 数 据 库 编 程」· SQL 代码 · 共 12 行

/*
if exists(select * from Region where RegionID = 5)
begin
  update Region set RegionDescription = 'EastSouth' where RegionID = 5
end
else
begin
  insert into Region(RegionID, RegionDescription) values(5, 'Middle')
end
*/

select top 20 * from Orders order by OrderID desc