摘要:
--外部参数declare@hotelIDsnvarchar(4000)set@hotelIDs='1,2,3,4,5,6,7,8,9,'--内部参数declare@hotelidnvarchar(8),@lengthint,@indexintcreatetable#tmp(idnvarchar(8));set@length=len(@hotelIDs)-len(replace(@hotelIDs,',',''));set@index=1;while@index<=@lengthbeginset@hotelid='';set
阅读全文