做个if判断,条件是
select sdate from songinfo where datediff(dd,sdate,getdate())>0
如果条件成立,它执行“update songinfo set dayhit=1”;
不成立的话,执行select * from songinfo ;
SQL语句怎么写???
select sdate from songinfo where datediff(dd,sdate,getdate())>0
如果条件成立,它执行“update songinfo set dayhit=1”;
不成立的话,执行select * from songinfo ;
SQL语句怎么写???
update songinfo set dayhit=1else
select * from songinfo
begin
update songinfo set dayhit=1
endelse
begin
select * from songinfo
end
select max(sdate) from songinfo where datediff(dd,sdate,getdate())>0
这句话错在哪?
怎么改?
update songinfo set dayhit=1else
select * from songinfo
怎么错了!!!
update songinfo set dayhit=1else
select * from songinfo
怎么错了!!!----------------------------
--if exists (select datediff(dd, max(sdate), getdate()) from songinfo>0)
if (select datediff(dd, max(sdate), getdate()) from songinfo) > 0
update songinfo set dayhit=1
else
select * from songinfo
select sdate from songinfo where datediff(dd,sdate,getdate())>0
如果条件成立,它执行“update songinfo set dayhit=1”;
不成立的话,执行select * from songinfo ;
SQL语句怎么写???--------------
if exists(select 1 from t where datediff(dd,sdate,getdate())>0 )
update songinfo set dayhit=1
else
select * from songinfo