newrpt.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewRpt
 @RptID int,
 @GroupID int,
 @RptName nvarchar(512),
 @RptDesc nvarchar(1024),
 @RptCallName nvarchar(512),
 @RptWidth int,
 @RptHeight int,
 @RightID int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8)
as
 insert Js_Rpt(Js_RptID,Js_GroupID,Js_RptName,Js_RptDesc,Js_RptCallName,Js_RptWidth,Js_RptHeight,Js_RightID,Js_UserID,Js_Date,Js_Time)
 values(@RptID,@GroupID,@RptName,@RptDesc,@RptCallName,@RptWidth,@RptHeight,@RightID,@UserID,@Date,@Time)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO