新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------
-- 读取 xml 成 table

select * from (
   --------------------------------------------------------------------------------------------
      select

a1.value('(Seq)[1]', 'int') AS Seq,
         a1.value('(FUserId/User/Id)[1]', 'int') AS UserId,
         a1.value('(FUserId/User/Name)[1]', 'nvarchar(50)') AS UserName,
         a1.value('(FType)[1]', 'nvarchar(50)') AS FType,
         a1.value('(FValue)[1]', 'int') AS FValue

from t_Bas_SysParameter

cross apply  FParameters.nodes('/FHead/FEntity/FEntity')  T(a1)

where FParameterObjId = 'aGsf_SysSet'
   --------------------------------------------------------------------------------------------
   ) a where UserName = '郭少锋'

/*
   select FParameters  from t_Bas_SysParameter  where FParameterObjId = 'aGsf_SysSet'

------------------------------------------------------------------------------------------------------------------------
-- 取得 xml

<FHead>
     <FEntity>
       <FEntity>
         <Id>1</Id>
         <Seq>1</Seq>
         <FUserId_Id>100076</FUserId_Id>
         <FUserId>
           <User>
             <Id>100076</Id>
             <Name>郭少锋</Name>
             <UserAccount>gsf</UserAccount>
           </User>
         </FUserId>
         <FType>年</FType>
         <FValue>1</FValue>
       </FEntity>
       <FEntity>
         <Id>2</Id>
         <Seq>2</Seq>
         <FUserId_Id>133043</FUserId_Id>
         <FUserId>
           <User>
             <Id>133043</Id>
             <Name>测试</Name>
             <UserAccount>cs</UserAccount>
           </User>
         </FUserId>
         <FType>月</FType>
         <FValue>2</FValue>
       </FEntity>
     </FEntity>
   </FHead>
------------------------------------------------------------------------------------------------------------------------
*/