newfieldcontrol.sql

本系统是一个报表分析查询系统

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewFieldControl
 @FieldControlID int,
 @RptID int,
 @FieldName nvarchar(50),
 @FieldDsecID int,
 @FieldDsec nvarchar(50),
 @FieldLen int,
 @FieldWidth int,
 @FieldAlign int,
 @FieldShowSign int,
 @RightID int,
 @FieldOrderID int,
 @FieldOrderSign int
as
 insert Js_FieldControl(Js_FieldControlID,Js_RptID,Js_FieldName,Js_FieldDsecID,Js_FieldDsec,Js_FieldLen,Js_FieldWidth,Js_FieldAlign,Js_FieldShowSign,Js_RightID,Js_FieldOrderID,Js_FieldOrderSign)
  values(@FieldControlID,@RptID,@FieldName,@FieldDsecID,@FieldDsec,@FieldLen,@FieldWidth,@FieldAlign,@FieldShowSign,@RightID,@FieldOrderID,@FieldOrderSign)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO