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


CREATE PROC [dbo].cs_Folder_AddFolder
	@UserID INT,
	@FolderName NVARCHAR(50),
	@ParentFolderId INT = NULL,
	@SettingsID INT,
	@FolderId INT OUTPUT
AS

INSERT INTO cs_Folder
(
	UserId,
	FolderName,
	ParentFolderId,
	SettingsID
	
)
VALUES
(
	@UserId,
	@FolderName,
	@ParentFolderId,
	@SettingsID
)

SELECT @FolderId = @@IDENTITY


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

GRANT EXECUTE ON [dbo].cs_Folder_AddFolder  TO PUBLIC
GO