stored_CM_ATTACH_FILE_Log_Ins.txt
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 |
|