You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
39 lines
1.0 KiB
39 lines
1.0 KiB
USE FastMoneyPro_Remit
|
|
GO
|
|
|
|
|
|
ALTER PROCEDURE PROC_APPLICATION_LOGS_REFERRAL
|
|
(
|
|
@rowId BIGINT = NULL
|
|
,@logType VARCHAR(50) = NULL
|
|
,@tableName VARCHAR(100) = NULL
|
|
,@dataId VARCHAR(50) = NULL
|
|
,@user VARCHAR(30) = NULL
|
|
,@oldData VARCHAR(MAX) = NULL
|
|
,@newData VARCHAR(MAX) = NULL
|
|
,@module VARCHAR(50) = NULL
|
|
,@tableDescription VARCHAR(50) = NULL
|
|
,@createdBy VARCHAR(30) = NULL
|
|
,@createdDate DATETIME = NULL
|
|
,@sortBy VARCHAR(50) = NULL
|
|
,@sortOrder VARCHAR(5) = NULL
|
|
,@pageSize INT = NULL
|
|
,@pageNumber INT = NULL
|
|
,@IP VARCHAR(50) = NULL
|
|
,@Reason VARCHAR(2000) = NULL
|
|
,@UserData VARCHAR(max) = NULL
|
|
,@fieldValue VARCHAR(2000) = NULL
|
|
,@agentId VARCHAR(20) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SET XACT_ABORT ON;
|
|
|
|
INSERT INTO dbo.REFERRAL_LOGIN_LOGS
|
|
(
|
|
referralUserId,logType,IP,Reason,
|
|
fieldValue,createdBy,createdDate,UserData
|
|
)
|
|
SELECT
|
|
@agentId,@logType,@IP,@Reason,
|
|
@fieldValue,@user,GETDATE(),@UserData
|