sqlserver 利用一列的值去更新另外一列,判断是否大于当前时间,不是就加上五年,再判断
declare @count int
declare @i int
set @i = 1
set @count = (select max(id) from [dbo].[numas_employee_certificate])
while @i<=@count
begin
declare @valid_date datetime
set @valid_date = (select cert
原创
2017-06-12 16:18:19 ·
2176 阅读 ·
0 评论