--建立存储过程
create proc test
@id varchar(20),
@date datetime
as
set nocount on
begin
delete from a where date between dateadd(day,-2,@date) and dateadd(day,2,@date)
end
begin
insert into a(id,date) values(@id,@date)
end
go
--执行存储过程
exec test 1,'2005-10-01'