OPENXML问题，空格被自动去除

declare @xml xml
DECLARE @idoc int select @xml='<Root>
  <List>
<contentstr>    aaaa    bbbb                             </contentstr>
  </List>
</Root>'select @xml = REPLACE(CONVERT(NVARCHAR(MAX),@xml),' ','@')  --转一下exec sp_xml_preparedocument @idoc output,@xml
SELECT  replace(contentstr,'@',' ') AS contentstr   --再转回来
FROM  OPENXML(@idoc, '/Root/List',2)
WITH(contentstr Nvarchar(max))