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

最新推荐文章于 2021-04-03 07:31:50 发布

lp0606

最新推荐文章于 2021-04-03 07:31:50 发布

阅读量759

点赞数

分类专栏：代码类文章标签：存储 .net mobile email qq

本文链接：https://blog.csdn.net/lp0606/article/details/4421787

版权

代码类专栏收录该内容

42 篇文章 1 订阅

订阅专栏

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

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