摘要： DECLARE @PreSOMasterXML XMLDECLARE @SDA VARCHAR(100)SET @PreSOMasterXML=N' CloseByVariable 1239 #DV_ApproveUserID# cz52 #DV_SONumber# 20127720 'SET @SDA = @PreSOMasterXML.value('(/ProcessTaskRequest/ActionType/text())[1]',N'nchar(100)')SELECT @SDA AS VARABLE 阅读全文