exists-top.sql

sql server 2000 系统 数 据 库 编 程

/*
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