怎么能把这个存储过程改成每天一条记录. 当初邹建帮助写的，希望帮改改。

Question

CREATE PROCEDURE p_urlcount @url varchar(1000) ASinsert T_count (url,date1,clickcount)
select @url,dateadd(day,datediff(day,0,getdate()),0),0
where not exists(select 1 
                   from T_count
                  where datediff(day,date1,getdate())=0)update T_count
set clickcount=clickcount+1
where url = @url and datediff(day,date1,getdate())=0

Answer 1

CREATE PROCEDURE p_urlcount @url varchar(1000) ASinsert T_count (url,date1,clickcount)
select @url,dateadd(day,datediff(day,0,getdate()),0),0
where not exists(select 1 
                   from T_count
                  where url = @url and datediff(day,date1,getdate())=0)update T_count
set clickcount=clickcount+1
where url = @url and datediff(day,date1,getdate())=0