abasfar
سه شنبه 23 شهریور 1389, 16:07 عصر
سلام ببخشید کسی میتونه خط 14 من توری تغییر بده که بشه رد شدفقط نگین که درمورد کد توضیح بدم که واقعا من عاجزم
ALTER PROCEDURE [dbo].[RegisterErorr]
(
@Url nvarchar(500)
,@Row nvarchar(500)
,@Message nvarchar(500)
,@Source nvarchar(500)
,@StackTrace nvarchar(1000)
,@TargetSite nvarchar(500)
,@IPAdress char(15)
)
AS
If (@Message = any(select [Message] from [T_Error])) and (@Row = any(select [Row] from [T_Error]))
Begin
if(exists(convert(nvarchar , getdate(),111)= convert(nvarchar ,(select DateEvent from [T_Error]),111)) and exists(convert(nvarchar , getdate(),111)= convert(nvarchar , (select DateEvent from [T_Error]),111) and exists(convert(nvarchar ,(select DateEvent from [T_Error]),108) between convert(nvarchar , dateadd(hour,-1,getdate()),108) and convert(nvarchar , getdate(),108) ))
begin
update [T_Error]
Set [Count] = [Count] + 1
where (@Message =[Message]) and (@Row = Row)
end
else
begin
INSERT INTO T_Error
(Url, Row, [Message], Source, StackTrace, TargetSite, IPAdress, DateEvent,[count])
VALUES (@Url,@Row,@Message,@Source,@StackTrace,@TargetSit e,@IPAdress,getdate(),1)
end
End
Else
begin
INSERT INTO T_Error
(Url, Row, [Message], Source, StackTrace, TargetSite, IPAdress, DateEvent,[count])
VALUES (@Url,@Row,@Message,@Source,@StackTrace,@TargetSit e,@IPAdress,getdate(),1)
end
ALTER PROCEDURE [dbo].[RegisterErorr]
(
@Url nvarchar(500)
,@Row nvarchar(500)
,@Message nvarchar(500)
,@Source nvarchar(500)
,@StackTrace nvarchar(1000)
,@TargetSite nvarchar(500)
,@IPAdress char(15)
)
AS
If (@Message = any(select [Message] from [T_Error])) and (@Row = any(select [Row] from [T_Error]))
Begin
if(exists(convert(nvarchar , getdate(),111)= convert(nvarchar ,(select DateEvent from [T_Error]),111)) and exists(convert(nvarchar , getdate(),111)= convert(nvarchar , (select DateEvent from [T_Error]),111) and exists(convert(nvarchar ,(select DateEvent from [T_Error]),108) between convert(nvarchar , dateadd(hour,-1,getdate()),108) and convert(nvarchar , getdate(),108) ))
begin
update [T_Error]
Set [Count] = [Count] + 1
where (@Message =[Message]) and (@Row = Row)
end
else
begin
INSERT INTO T_Error
(Url, Row, [Message], Source, StackTrace, TargetSite, IPAdress, DateEvent,[count])
VALUES (@Url,@Row,@Message,@Source,@StackTrace,@TargetSit e,@IPAdress,getdate(),1)
end
End
Else
begin
INSERT INTO T_Error
(Url, Row, [Message], Source, StackTrace, TargetSite, IPAdress, DateEvent,[count])
VALUES (@Url,@Row,@Message,@Source,@StackTrace,@TargetSit e,@IPAdress,getdate(),1)
end