今天维护数据库中写的一些动态更新脚本,留着以后用:
--声明变量
declare @emp_id nvarchar(100),@zs_no nvarchar(50),@sx_email nvarchar(100),@zs_email nvarchar(100),@name nvarchar(100),@sx_no nvarchar(100)
--初始化变量
select top 1 @emp_id = [employee_id],@zs_no = s.正式工号,@zs_email = s.新邮件地址,@name = s.显示名
from [employee_information] ei
join Sheet1$ s on ei.[employee_account] = s.实习工号
where s.flag is null
update [employee_information]
set [employee_account] = @zs_no,[employee_no] = @zs_no,[email_address] = @zs_email,[employee_name] = @name
where [employee_id] = @emp_id
--更改flag的值
update Sheet1$
set flag = 1
where 正式工号 = @zs_no
批量更改数据库信息
最新推荐文章于 2024-07-23 14:05:29 发布