更新时间:2023-11-09 23:38:46
试试这个:
declare @xml xml = '<PermanentAddress> <AddressLine><![CDATA[1234 1st street]]> </AddressLine> <City>test</City> </PermanentAddress>' select @xml.value('(/PermanentAddress/AddressLine)[1]', 'nvarchar(100)')
使用 CharIndex、Len 和 Substring 从列中定位某些信息