做一个job每天检查select * from YouTabel
where dateCol = getdate()
if @@rowcount = 0
begin
insert YouTable(......)
values(......)
end
where dateCol = getdate()
if @@rowcount = 0
begin
insert YouTable(......)
values(......)
end
难道这些重复的数据有用吗
values(......)
这句应该怎么写?目的是复制昨天的数据,包括好多字段呢
where rq = getdate()if @@rowcount = 0
begin
insert into Tabname(col1,col2,rq)
select col1,col2,getdate as rq from Tabname
where rq = getdate() - 1
end
怎么办?
在SQL SERVER里判断某天是星期几的函数有吗?