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通用软件开发系统 阅读(307) 评论(0) 收藏 举报
浙公网安备 33010602011771号