create proc p_test
as
--取得记录显示
select * from user_data order by update_last --更新记录的update_last为getdate()
update user_data set update_last=getdate()
go
as
--取得记录显示
select * from user_data order by update_last --更新记录的update_last为getdate()
update user_data set update_last=getdate()
go
set nocount on
set rowcount 500
---设user_id为user_date的一个主键
update user_data set update_last=getdate() from (select top 500 User_id from user_date order by update_last) temp where temp.user_id=user_date.User_idselect top 500 User_id from user_date order by update_last
select [User_id] from user_dateset rowcount 0