不能这样使用case ... when ...
DECLARE @HOUR int
set @HOUR=datename(hour,getdate())if @HOUR=1
Update A Set a=
(select b from B where A.ChnID=B.ChnID and(A.daytime =
datename(year,getdate())+'-'+datename(month,getdate())+'-'+datename(day,getdate())))
if @HOUR=2
....
end
DECLARE @HOUR int
set @HOUR=datename(hour,getdate())if @HOUR=1
Update A Set a=
(select b from B where A.ChnID=B.ChnID and(A.daytime =
datename(year,getdate())+'-'+datename(month,getdate())+'-'+datename(day,getdate())))
if @HOUR=2
....
end
问个问题:
作业是否需要一个专门的操作员来管理?
使用应用程序实现和作业的区别