第一问答网»论坛 › 中问网 › 问答 › 存储过程里 sql2000 更新一个表的前2条记录怎么做? ...

存储过程里 sql2000 更新一个表的前2条记录怎么做?

11 |

5 | 2012-8-24 09:55:12 | 显示全部楼层 |阅读模式

sqlserver：update ec_store_order_card setusestatus='02' where orderid in (select top 2 orderid from ec_store_order_card where orderid='00000003'order by orderid )...

使用道具举报

千问 | 2012-8-24 09:55:12 | 显示全部楼层

UPDATE ec_store_order_cardSET usestatus='02'FROM (SELECTtop @ordercount_differ orderid from ec_store_order_cardwhere orderid=@orderid order by orderid ASC) AS cdtWHER...

使用道具举报