gds通用软件开发系统

导航

sql中while遍历更新字段数据

while exists(select 1 from xlhhis..emrzy_doclist where docbill is null)
begin
update xlhhis..emrzy_doclist set docbill=[dbo].[fun_emr_docbill]('') where objid=
(select top 1 objid from xlhhis..emrzy_doclist  where docbill is null)
end

posted on 2010-07-22 08:49  gds通用软件开发系统  阅读(301)  评论(0编辑  收藏  举报