cs_roller_addfeed.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_Roller_AddFeed]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_Roller_AddFeed]
GO


CREATE PROC [dbo].cs_Roller_AddFeed
	@UserId INT,
	@FeedId INT
AS


INSERT INTO cs_FolderFeed
(
	UserId,
	FolderId,
	FeedId
)
VALUES
(
	@UserId,
	NULL,
	@FeedId
)


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

GRANT EXECUTE ON [dbo].cs_Roller_AddFeed  TO PUBLIC
GO