41 lines
849 B
Transact-SQL
41 lines
849 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_SetPacketOverload]
|
|
@func_name char(100),
|
|
@time int
|
|
as
|
|
set nocount on
|
|
|
|
|
|
declare @createtime datetime
|
|
set @createtime = getdate()
|
|
|
|
declare @year varchar(50)
|
|
declare @month varchar(50)
|
|
|
|
set @year = convert(varchar, datepart(yy,@createtime))
|
|
set @month = convert(varchar, datepart(mm,@createtime))
|
|
|
|
set xact_abort on
|
|
begin tran
|
|
|
|
declare @updatesql nvarchar(500)
|
|
|
|
-- PacketOverload_Log ??? ??
|
|
exec Local_CreatePacketOverloadLogTable @createtime
|
|
|
|
|
|
SET @updatesql ='insert into PacketOverload_Log_'+ @year+'_'
|
|
+@month+'(func_name, time, date)
|
|
values ('
|
|
+ '''' +convert(nvarchar, @func_name)+ '''' + ','
|
|
+ '''' +convert(nvarchar, @time)+ '''' + ','
|
|
+ '''' +convert(nvarchar, @createtime)+ '''' + ')'
|
|
EXEC(@updatesql)
|
|
|
|
|
|
if(@@error <> 0)
|
|
begin
|
|
rollback
|
|
return
|
|
end
|
|
|
|
commit
|