Project

General

Profile

stored_CM_ATTACH_FILE_Log_Ins.txt

Luc Tran Van, 10/15/2022 05:01 PM

 
1
CREATE PROCEDURE [dbo].[CM_ATTACH_FILE_LOG_Ins] 
2
						@p_PATH nvarchar(1000), 
3
						@p_OLD_PATH nvarchar(1000), 
4
						@p_ACTION nvarchar(100),
5
						 @p_FILE_SIZE decimal,
6
						 @p_FILE_TYPE varchar(50),
7
						 @p_USER_NAME varchar(15),
8
						 @p_NOTES nvarchar(1000)
9
as
10
begin
11
	INSERT INTO CM_ATTACH_FILE_LOG([ACTION],[PATH],[OLD_PATH],[FILE_SIZE],[FILE_TYPE],[USER_NAME],[NOTES],[ACTION_DT])
12
	VALUES (@p_ACTION,@p_PATH,@p_OLD_PATH,@p_FILE_SIZE,@p_FILE_TYPE,@p_USER_NAME,@p_NOTES,GETDATE())
13
	SELECT '0' as Result, '' ID, '' ErrorDesc
14
end
15
GO
16

    
17