[BTS] Use TSQL to query a XML field in SQLServer
摘要:
When deploy BizTalk application. I often save XML message to database.When display some field in XML, I need following SQL to query XML field.starttime,selectconvert(xml,RequestXML).value('(//GENERALDATA/SERIAL_NO)[1]','varchar(30)')SERIAL_NOfromBizTalkTaskwhereinterfaceid=10001order 阅读全文
posted @ 2012-12-03 16:37 徐中 阅读(359) 评论(0) 推荐(0) 编辑