CREATE PROCEDURE [dbo].[CM_ATTACH_FILE_LOG_Ins] @p_PATH nvarchar(1000), @p_OLD_PATH nvarchar(1000), @p_ACTION nvarchar(100), @p_FILE_SIZE decimal, @p_FILE_TYPE varchar(50), @p_USER_NAME varchar(15), @p_NOTES nvarchar(1000) as begin INSERT INTO CM_ATTACH_FILE_LOG([ACTION],[PATH],[OLD_PATH],[FILE_SIZE],[FILE_TYPE],[USER_NAME],[NOTES],[ACTION_DT]) VALUES (@p_ACTION,@p_PATH,@p_OLD_PATH,@p_FILE_SIZE,@p_FILE_TYPE,@p_USER_NAME,@p_NOTES,GETDATE()) SELECT '0' as Result, '' ID, '' ErrorDesc end GO