with xmlnamespaces(default'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'),CTE as(
SELECT
TOP 13
C.ItemID,
C.Name AS [ReportName],
CONVERT(XML, CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), C.CONTENT))) AS[ReportDeffinitionXML]
FROM
[ReportServer].[dbo].[Catalog] AS C
WHERE
C.Type = 2
)
select[ReportDeffinitionXML].value('(/Report/AutoRefresh)[1]', 'int' ) from CTE
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024