任选5000条update 表 set cvcDate = getdate() where cbSign = 1 and ciID in (Select top 5000 ciID from 表 a where cbSign = a.cbSign order by newid())
update Table1 set cvcDate=getdate() from (select top 100 * from Table1 where cbSign=1 order by newid()) a where ciId=a.ciId and cbSign=a.cbSign and cvcDate=a.cvcDate
where cbSign = a.cbSign order by newid()有什么作用啊?如果我要再把已经插入日期的选择出来怎么做啊?
--如果ciId为主键 insert into #a select top 1000 * from Table1 where cbSign=1 order by newid() update Table1 set cvcDate=getdate() from #a a where cvcDate=a.cvcDate select * from #a
或者: declare @date datetime set @date=getdate() update table1 set cvcDate=@date where ciID in (select top 1000 ciID from table1 where cbsign=1 order by newid) select * from table1 where cvcDate=@date
where cbSign = 1 and ciID in (Select top 5000 ciID from 表 a where cbSign = a.cbSign order by newid())
set cvcDate=getdate() from
(select top 100 * from Table1 where cbSign=1 order by newid()) a
where ciId=a.ciId and cbSign=a.cbSign and cvcDate=a.cvcDate
insert into #a select top 1000 * from Table1 where cbSign=1 order by newid()
update Table1
set cvcDate=getdate() from #a a
where cvcDate=a.cvcDate
select * from #a
declare @date datetime
set @date=getdate()
update table1
set cvcDate=@date where ciID in (select top 1000 ciID from table1 where cbsign=1 order by newid)
select * from table1 where cvcDate=@date