USP_LOADSPECLOG_ADDLOGENTRY

Parameters

Parameter	Parameter Type	Mode
@SPECTYPE	nvarchar(255)	IN
@SPECNAME	nvarchar(255)	IN
@SPECID	uniqueidentifier	IN
@LOADSOURCENAME	nvarchar(255)	IN
@LOADITEMNAME	nvarchar(255)	IN
@SPECHASHCODE	nvarchar(255)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy


            create procedure dbo.USP_LOADSPECLOG_ADDLOGENTRY

            @SPECTYPE nvarchar(255) ,
            @SPECNAME nvarchar(255) ,
            @SPECID uniqueidentifier ,
            @LOADSOURCENAME nvarchar(255) ,
            @LOADITEMNAME nvarchar(255) ,
            @SPECHASHCODE nvarchar(255) ,
            @CHANGEAGENTID uniqueidentifier 



            /*
            Used by dbo.USP_LOADSPEC to record the loading of a spec.
            */


            as 

            set nocount on;

            INSERT INTO dbo.LOADSPECLOG 
            (SPECTYPE,SPECNAME,SPECID,LOADSOURCENAME,LOADITEMNAME,SPECHASHCODE,ADDEDBYID,CHANGEDBYID) 
            VALUES 
            (@SPECTYPE,@SPECNAME,@SPECID,@LOADSOURCENAME,@LOADITEMNAME,@SPECHASHCODE,@CHANGEAGENTID,@CHANGEAGENTID)
            ;