.net 存储过程 --时间相减

Create procedure BillContentDeadline
as
declare @recordercount int
select @recordercount = count(*) from  dbo.DeadlineView where Deadline=0 or Deadline<0
if (@recordercount>0)
begin
update DeadlineView set AuditingState='已到期' where Deadline =0 and AuditingState='已审核'
update DeadlineView set AuditingState='已到期' where Deadline <0 and AuditingState='已审核'
end

 

-----------------------创建存储过程

 

 

SELECT     DATEDIFF(d, GETDATE(), PublishEndTime) AS Deadline(关键), BillID, ProvinceID, CityID, PublishType, LinkType, BillName, BillDescription, PublishStartTime,
                      PublishEndTime（关键）, EnterPriseAdress, EnterPriseURL, Email, RelationPerson, Headship, OfficeTel, Mobile, QQ, Remark, PublishContent, LinkURL,
                      AuditingState, ChannelID, SecondTypeID, BillImage, ProvinceName, ChannelName, SecondTypeName, cityName, FirstLocationID, SecondLocationID,
                      FirstLocationName, SecondLocationName
FROM  dbo.BillContent_View

 

 

------------------------创建视图