newlog.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewLog
 @LogID int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8),
 @IP nvarchar(15),		
 @Mac nvarchar(17),
 @EventID int
as
 insert Js_Log(Js_LogID,Js_UserID,Js_Date,Js_Time,Js_IP,Js_Mac,Js_EventID)
 values(@LogID,@UserID,@Date,@Time,@IP,@Mac,@EventID)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO