newrptgroup.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewRptGroup
 @GroupID int,
 @ParentID int,
 @Number nvarchar(16),
 @GroupName nvarchar(128),
 @RptList nvarchar(4000),
 @Desc nvarchar(512),
 @Level int,
 @Detail int,
 @UseSign int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8),
 @Ico nvarchar(128),
 @Sel nvarchar(128)
as
 insert Js_RptGroup(Js_GroupID,Js_ParentID,Js_Number,Js_GroupName,Js_RptList,Js_Desc,Js_Level,Js_Detail,Js_UseSign,Js_UserID,Js_Date,Js_Time,Js_Ico,Js_Sel)
 values(@GroupID,@ParentID,@Number,@GroupName,@RptList,@Desc,@Level,@Detail,@UseSign,@UserID,@Date,@Time,@Ico,@Sel)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO