Question

我如何在 s升服务器中制造真正空的xml元素(2005年)。

例:

select
      
for xml path( element ), root( elements )

产出:

<elements><element></element></elements>

但我确实想要的是:

<elements><element /></elements>

Answer 1

添加此类指令,然后将其置于分局。

与此类似:

select
(
    select
          
    for xml path( element ), type
)
for xml path( elements )

Answer 2

select
    null
for xml path( element ), root( elements )

Answer 3

仅需要了解价值是否无效,具体如下:ISNUL(外勤人员,。

与此类似:

DECLARE @T table
(
  ID int identity primary key,
  Name nvarchar(10)
)
INSERT INTO @T (Name)
    SELECT  Name1 
    UNION ALL
    SELECT NULL

-- @Result1
SELECT  ID AS Id
        ,ISNULL(Name,   ) AS Name
FROM @T
FOR XML PATH ( Person )

-- @Result2
DECLARE @Result2 XML = ( SELECT
                            ID AS Id
                            ,ISNULL(Name,   ) AS Name
                        FROM @T
                        FOR XML PATH ( Person ))
SELECT @Result2;

成果1:

<Person>
  <Id>1</Id>
  <Name>Name1</Name>
</Person>
<Person>
  <Id>2</Id>
  <Name></Name>
</Person>

成果:

<Person>
  <Id>1</Id>
  <Name>Name1</Name>
</Person>
<Person>
  <Id>2</Id>
  <Name />
</Person>

友情链接