摘要:
DECLARE@xXMLSELECT@x='<Peoples><PeopleNAME="周星驰"/><PeopleNAME="刘德华"/><PeopleNAME="周杰伦"/></Peoples>'--------------------------------------------------------------"周杰伦"向上移动... 阅读全文
摘要:
--createtableDECLARE@companiesTable(CompanyIDINT,CompanyCodesVARCHAR(100))--insertdatainsertinto@companies(CompanyID,CompanyCodes)values(1,'1|2')insertinto@companies(CompanyID,CompanyCodes)values(2,'1... 阅读全文
摘要:
DECLARE@xXMLSELECT@x='<Root><Variables><VariableVariableName="V1"Value="1"/><VariableVariableName="V2"Value="2"/><VariableVariableName="V3"Value="3"/></Variables>&l... 阅读全文
摘要:
DECLARE@xXMLSELECT@x='<People><dongshengid="2"><InfoName="Email">dongsheng@xxyy.com</Info><InfoName="Phone">678945546</Info><InfoName="qq"mark="中国">36575</... 阅读全文