cs_postattachment_add.prc

解压即可使用

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

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










create procedure [dbo].cs_PostAttachment_Add 
(
	@PostID int,
	@UserID int,
	@SectionID int,
	@Filename nvarchar(256),
	@Content image,
	@ContentType nvarchar(50),
	@ContentSize int,
	@SettingsID int
)
AS
SET Transaction Isolation Level Read UNCOMMITTED
BEGIN

	IF EXISTS (SELECT PostID FROM cs_PostAttachments WHERE PostID = @PostID and SettingsID = @SettingsID )
	begin
		UPDATE cs_PostAttachments SET
			[FileName] 	= @Filename,
			Content		= @Content,
			ContentSize	= @ContentSize
		WHERE
			PostID		= @PostID and
			SettingsID		= @SettingsID	
	end
	else
	begin
		INSERT INTO 
			cs_PostAttachments
		(
			PostID,
			SectionID,
			UserID,
			[FileName],
			Content,
			ContentType,
			ContentSize,
			SettingsID
		)
		VALUES
		(
			@PostID,
			@SectionID,
			@UserID,
			@Filename,
			@Content,
			@ContentType,
			@ContentSize,
			@SettingsID
		)
	end
END



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

grant execute on dbo.[cs_PostAttachment_Add] to public
go