USP_INSERT_DirectorySearchStats
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @UserName | nvarchar(50) | IN | |
| @PageID | int | IN | |
| @PartID | int | IN |
Definition
Copy
create procedure dbo.USP_INSERT_DirectorySearchStats
@UserName nvarchar(50),
@PageID int,
@PartID int
as
begin
declare @CHANGEAGENTID uniqueidentifier;
exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
INSERT INTO [dbo].[DIRECTORYSEARCHSTATS]
([USERNAME] , [PAGEID], [PARTID],[ADDEDBYID],[CHANGEDBYID])
VALUES
(@UserName , @PageID, @PartID, @CHANGEAGENTID, @CHANGEAGENTID)
end