declare @time varchar(8),@datetime datetime
declare cursor_time cursor for select right(datetime,8) from att_original where left(datetime,10) = '06 11 2003'
open cursor_time
fetch next from cursor_time into @time
declare cursor_user cursor for select * from att_original where left(datetime,10) = '06 11 2003'
open cursor_user
fetch next from cursor_user
while @@fetch_status = 0
begin
set @datetime = '2005-06-11 '+ '' + @time
update att_original set datetime = @datetime where current of cursor_user
fetch next from cursor_user
fetch next from cursor_time into @time
end
close cursor_user
deallocate cursor_user
close cursor_time
deallocate cursor_time
select * from att_original
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。