newtitle.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO


CREATE procedure NewTitle
 @TitleID int,
 @RptID int,
 @SRow int,
 @ERow int,
 @SCol int,
 @ECol int,
 @Text nvarchar(1024)
as
 insert Js_Title(Js_TitleID,Js_RptID,Js_SRow,Js_ERow,Js_SCol,Js_ECol,Js_Text)
 values(@TitleID,@RptID,@SRow,@ERow,@SCol,@ECol,@Text)

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO