我有以下SQL查询:
declare @x xml
set @x = '<IDs><ID>1</ID><ID>2</ID></IDs>'
SELECT @x.query('/IDs/ID') as ID
这将返回以下结果:
ID
--------------------
<ID>1</ID><ID>2</ID>
我该如何才能得到以下返回结果:
ID
--
1
2
我有以下SQL查询:
declare @x xml
set @x = '<IDs><ID>1</ID><ID>2</ID></IDs>'
SELECT @x.query('/IDs/ID') as ID
ID
--------------------
<ID>1</ID><ID>2</ID>
ID
--
1
2
declare @x xml
set @x = '<IDs><ID>1</ID><ID>2</ID></IDs>'
SELECT ID.value('.', 'int') AS ID
FROM @x.nodes('/IDs/ID') as IDS(ID)