将序言添加到sql生成的xml中 [英] Add prologue to an xml generated by sql

问题描述

我需要一些帮助来为sql server 2008中生成的xml添加序言，因为我已经尝试过很多东西但没有任何作用。



问题在于这个sql：

Hi,

I need some help to add prologue to an generated xml from sql server 2008 because i have tried many things and nothing works.

the problem is with this sql :

declare @r nvarchar(4000) --is for output

set @r = N'select * from (' + @dbname + N').dbo['+ @fntName + N'](' + @parameters + N')' + @orderby + N')' + @orderby + N' for xml explicit'

我想将此追加到@r：





我喜欢这样但它不起作用：

and i want to append this to @r :


I do like this but it doesn't work :

declare @strXML as nvarchar(max)
set @strXML = N'select ''"" + N'+ @strXML

推荐答案

这里的任何一个都有意义吗？

Does any of this here make sense?

declare @r[nvarchar](4000) --is for output
declare @dbname [nvarchar](34)
SET @dbname = 'MyDatabase'
DECLARE @fntName [nvarchar](35)
SET @fntName = 'EceteraLite'
DECLARE @parameters [nvarchar](36)
SET @parameters = 'gettinfunkyfastnow'
DECLARE @orderby01 [nvarchar](37)
SET @orderby01 = 'columnZ'
DECLARE @orderby02 [nvarchar](38)
SET @orderby02 = 'DESC'
 
--set @r = N'select * from (' + @dbname + N').dbo['+ @fntName + N'](' + @parameters + N')' + @orderby01 + N')' + @orderby02 + N' for xml explicit'
set @r = 'select * from [' + @dbname + '].[dbo].['+ @fntName + ']('+ @parameters + ') ORDER BY [' + @orderby01 + '] ' + @orderby02 + ' for xml explicit'
PRINT @r

将在消息中输出：

Which will output in Messages:

select * from [MyDatabase].[dbo].[EceteraLite](gettinfunkyfastnow) ORDER BY [columnZ] DESC for xml explicit

这篇关于将序言添加到sql生成的xml中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！