Загрузка данных


USE [replTransVas];
GO

SELECT
    s.name AS schemaName,
    o.name AS objectName,
    DATALENGTH(m.definition) AS definitionBytes,
    m.definition AS actualDefinition
FROM sys.objects o
JOIN sys.schemas s ON s.schema_id = o.schema_id
JOIN sys.sql_modules m ON m.object_id = o.object_id
WHERE s.name = N'dbo'
  AND o.name IN (N'reportMaxKod', N'K_view_gr_mobile')
ORDER BY o.name
FOR XML PATH('Object'), ROOT('Definitions'), TYPE;