newfielddsec.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewFieldDsec
 @FieldDsecID int,
 @FieldTypeID int,
 @Js_FieldDesc nvarchar(50),
 @FieldDecimal int,
 @FieldDateFormat nvarchar(50),
 @FieldClassID int,
 @FieldSelType int
as
 insert Js_FieldDsec(Js_FieldDsecID,Js_FieldTypeID,Js_FieldDesc,Js_FieldDecimal,Js_FieldDateFormat,Js_FieldClassID,Js_FieldSelType)
  values(@FieldDsecID,@FieldTypeID,@Js_FieldDesc,@FieldDecimal,@FieldDateFormat,@FieldClassID,@FieldSelType)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO