sql xml 查询

  Select A.*,R.Description,O.AltOrderNum 'OrderNum',
   cast(cast(T.[Name] as xml).query('/Languages/Language[@code=''en'']') as nvarchar(max)) as [EnglishName],b.Balance
   From [tbl_Commission_Ledger] A WITH (NOLOCK)