newevent.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewEvent
 @EventID int,
 @EventDesc nvarchar(1024)
as
 insert Js_Event(Js_EventID,Js_EventDesc)
  values(@EventID,@EventDesc)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO