DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

DECLARE @FILE_NAME_OLD NVARCHAR(MAX) = NULL,

    		@FILE_NAME_NEW NVARCHAR(MAX) = NULL,

    		@PATH_NEW NVARCHAR(MAX) = NULL

--

SELECT TOP 1 

  @FILE_NAME_OLD = FILE_NAME_OLD,

  @FILE_NAME_NEW = FILE_NAME_NEW,

  @PATH_NEW = PATH_NEW  

FROM CM_ATTACH_FILE_HIST WHERE ID = 25831

--

UPDATE CM_ATTACH_FILE

SET FILE_NAME_OLD = @FILE_NAME_OLD,

    FILE_NAME_NEW = @FILE_NAME_NEW,

    PATH_NEW = @PATH_NEW

WHERE ATTACH_ID = 'CMAF00000769607'