试试这个

try this

SET @vQuery1='select B.schname as schname,COUNT(A.cname) as total_child from ' + @ChildTblName + ' A, 
               SCHMAST B where A.cname like ''%11111%'' and  B.DCODE='+ @DistrictID +' AND B.BCODE='+ @BlockID +'and B.VCODE='+ @VillageID +''