newheaderfooter.sql

来自「本系统是一个报表分析查询系统」· SQL 代码 · 共 30 行

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewHeaderFooter
 @HeaderFooterID int,
 @RptID int,
 @hfTypeID int,
 @hfText nvarchar(1024),
 @hfFontName nvarchar(50),
 @hfFontSize int,
 @hfFontBold int,
 @hfFontItalic int,
 @hfFontUnderline int,
 @HeaderFooterOrderID int
as
 insert Js_HeaderFooter(Js_HeaderFooterID,Js_RptID,Js_hfTypeID,Js_hfText,Js_hfFontName,Js_hfFontSize,Js_hfFontBold,Js_hfFontItalic,Js_hfFontUnderline,Js_HeaderFooterOrderID)
  values(@HeaderFooterID,@RptID,@hfTypeID,@hfText,@hfFontName,@hfFontSize,@hfFontBold,@hfFontItalic,@hfFontUnderline,@HeaderFooterOrderID)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO