Create update history

DECLARE @_xmlLayout NVARCHAR(MAX), @_xmlObject NVARCHAR(MAX)
 
-- Tạo file update Layout.
SET @_xmlLayout = (
	SELECT FormName, LayoutName
	FROM B00Layout AS [Row]
	WHERE Row.FormName = 'EDIT_CMSProvider'
	ORDER BY FormName
	FOR XML AUTO, BINARY BASE64, root('root')
)
EXECUTE usp_sys_zCreateUpdateLayout
	@_xmlLayout = @_xmlLayout, 
	@_Path = '\\server\',
	@_FileName = 'B8R2U_LayoutUpdate.sql', 
	@_UpdateCommand = 1, @_CreateXMLFile = 0, 
	@_SqlUserConnect = '', @_SqlPasswordConnect = ''
 
-- Tạo file update Thủ tục, Hàm, View và Trigger.
SET @_@_xmlObjectxml = (
	SELECT name, type, OBJECT_NAME(parent_object_id) parent_name --,object_id, create_date, modify_date
	FROM sys.objects AS [Row]
	WHERE Name IN ('usp_B20Dept_AutoCreateTableLog')	
		AND Type IN ('P', 'V', 'FS', 'TR') -- Chỉ lấy Thủ tục (P), Hàm (FS), View (V), Trigger (TR)
	FOR XML AUTO, BINARY BASE64, root('root')
)
 
EXECUTE usp_sys_zCreateUpdateObject
	@_xmlLayout = @_xmlObject, 
	@_Path = '\\server\',
	@_FileName = 'B8R2_StoreProcUpdate.sql', 
	@_Recompile = 1,
	@_SqlUserConnect = '', @_SqlPasswordConnect = ''