[XML查询] xml大数据查询

SELECT COUNT(1) FROM [dbo].[ApplyLoan] WITH(NOLOCK) WHERE  DataType=2 and IsDelete=0  AND city in('深圳','天津','北京','苏州','广州','重庆','成都','青岛') AND [applycode] IN (SELECT T.N.value('applycode[1]','VARCHAR(50)') as applycode from @applycodeXml.nodes('//N') as T(N))
    @APPLYCODEXML='<Xml>
<N><applycode>201507138899</applycode></N>
<N><applycode>201507159170</applycode></N>
<N><applycode>201506267751</applycode></N>
<N><applycode>201506218362</applycode></N>
<N><applycode>201506216214</applycode></N>
<N><applycode>201506183312</applycode></N>
<N><applycode>201506131437</applycode></N>
<N><applycode>201506040173</applycode></N>
<N><applycode>201506046054</applycode></N>
<N><applycode>201506053101</applycode></N>
</Xml>'