向数据库里插入当天日期,如果日期存在计数加一,如果不存在插入并计数为一,请问SQL语句如何实现?declare @cnt as int select @cnt = count(*) + 1 from tb where convert(varchar(10),日期字段,120) = convert(varchar(10),getdate(),120)
create table # (date datetime, calc int)update # set calc=calc+1 where datediff(day,date,getdate())=0 if @@rowcount=0 insert # select datediff(day,0,getdate()),1 select * from #update # set calc=calc+1 where datediff(day,date,getdate())=0 if @@rowcount=0 insert # select datediff(day,0,getdate()),1 select * from #drop table #
create table # (date datetime, calc int)declare @calc intupdate # set calc=calc+1,@calc=calc+1 where datediff(day,date,getdate())=0 if @@rowcount=0 insert # select datediff(day,0,getdate()),1 select isnull(@calc,1)update # set calc=calc+1,@calc=calc+1 where datediff(day,date,getdate())=0 if @@rowcount=0 insert # select datediff(day,0,getdate()),1 select isnull(@calc,1)drop table #
select @cnt = count(*) + 1 from tb where convert(varchar(10),日期字段,120) = convert(varchar(10),getdate(),120)
if @@rowcount=0 insert # select datediff(day,0,getdate()),1
select * from #update # set calc=calc+1 where datediff(day,date,getdate())=0
if @@rowcount=0 insert # select datediff(day,0,getdate()),1
select * from #drop table #
if @@rowcount=0 insert # select datediff(day,0,getdate()),1
select isnull(@calc,1)update # set calc=calc+1,@calc=calc+1 where datediff(day,date,getdate())=0
if @@rowcount=0 insert # select datediff(day,0,getdate()),1
select isnull(@calc,1)drop table #