我有以下存储过程.
每当@logo为null时,将删除当前值.如果@logo为NULL,我想不更新logo的值.
IF OBJECT_ID ('kii.p_UpdateDocumentStyle') IS NOT NULL
DROP PROCEDURE kii.p_UpdateDocumentStyle
GO
CREATE PROCEDURE kii.p_UpdateDocumentStyle
@DocumentId AS INT,@TitleForegroundColor AS NVARCHAR(10),@TitleBackgroundColor AS NVARCHAR(10),@TitleFontFamily AS NVARCHAR(50),@TitleFontSize AS NVARCHAR(10),@TitleFontStyle AS NVARCHAR(10),@TitleFontWeight AS NVARCHAR(10),@TitleTextDecoration AS NVARCHAR(15),@SectionTitleForegroundColor AS NVARCHAR(10),@SectionTitleBackgroundColor AS NVARCHAR(10),@SectionTitleFontFamily AS NVARCHAR(50),@SectionTitleFontSize AS NVARCHAR(10),@SectionTitleFontStyle AS NVARCHAR(10),@SectionTitleFontWeight AS NVARCHAR(10),@SectionTitleTextDecoration AS NVARCHAR(15),@ParagraphForegroundColor AS NVARCHAR(10),@ParagraphBackgroundColor AS NVARCHAR(10),@ParagraphFontFamily AS NVARCHAR(50),@ParagraphFontSize AS NVARCHAR(10),@ParagraphFontStyle AS NVARCHAR(10),@ParagraphFontWeight AS NVARCHAR(10),@ParagraphTextDecoration AS NVARCHAR(15),@logo AS Image = NULL
AS
UPDATE kii.DocumentStyle
SET
TitleForegroundColor = @TitleForegroundColor,TitleBackgroundColor = @TitleBackgroundColor,TitleFontFamily = @TitleFontFamily,TitleFontSize = @TitleFontSize,TitleFontStyle = @TitleFontStyle,TitleFontWeight = @TitleFontWeight,TitleTextDecoration = @TitleTextDecoration,SectionTitleForegroundColor = @SectionTitleForegroundColor,SectionTitleBackgroundColor = @SectionTitleBackgroundColor,SectionTitleFontFamily = @SectionTitleFontFamily,SectionTitleFontSize = @SectionTitleFontSize,SectionTitleFontStyle = @SectionTitleFontStyle,SectionTitleFontWeight = @SectionTitleFontWeight,SectionTitleTextDecoration = @SectionTitleTextDecoration,ParagraphForegroundColor = @ParagraphForegroundColor,ParagraphBackgroundColor = @ParagraphBackgroundColor,ParagraphFontFamily = @ParagraphFontFamily,ParagraphFontSize = @ParagraphFontSize,ParagraphFontStyle = @ParagraphFontStyle,ParagraphFontWeight = @ParagraphFontWeight,ParagraphTextDecoration = @ParagraphTextDecoration,logo = @logo
WHERE
DocumentId = @DocumentId
GO
GRANT EXECUTE on kii.p_UpdateDocumentStyle TO p_role_kii
GO
