cs_feed_updatefeedstatus.prc

community server 源码

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_Feed_UpdateFeedStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_Feed_UpdateFeedStatus]
GO



CREATE PROC [dbo].cs_Feed_UpdateFeedStatus
	@FeedId INT,
	@FeedStateId INT
AS


UPDATE cs_Feed
SET	FeedStateId = @FeedStateId,
	LastUpdateDate = GetDate()
WHERE FeedId = @FeedId



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

GRANT EXECUTE ON [dbo].cs_Feed_UpdateFeedStatus  TO PUBLIC
GO