newfilt.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewFilt
 @FiltID int,
 @RptID int,
 @FieldControlID int,
 @LinkSign int,
 @Desc nvarchar(50),
 @OrderID int
as
 insert Js_Filt(Js_FiltID,Js_RptID,Js_FieldControlID,Js_LinkSign,Js_Desc,Js_OrderID)
  values(@FiltID,@RptID,@FieldControlID,@LinkSign,@Desc,@OrderID)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO