SELECT DISTINCT t1.StockAppNum,EmpNum,StockAppDate,ROUND(StockAppSum,2) AS StockAppSum,StockAppSign FROM
 StockApply AS t1 INNER JOIN StockApply_Two ON t1.StockAppNum=StockApply_Two.StockAppNum where
  StockAppSign=1 AND StockEndSign=0 AND StockApply_Two.StockAppNum LIKE '%y%'
直接执行没有问题，但使用存储过程后
'SELECT DISTINCT t1.'+@returnFld+' FROM '+@tblName+' AS t1 INNER JOIN '+@linkTblName +' ON t1.'+@fldName +'='+@linkTblName+'.'+@fldName

显示无法绑定由多个部分组成的标识符 "StockApply_Two.StockAppNum"。
 不知道是怎么回事？？

看下这 http://bbs.

use

把存储过程这个语句'SELECT DISTINCT t1.'+@returnFld+' FROM '+@tblName+' AS t1 INNER JOIN '+@linkTblName +' ON t1.'+@fldName +'='+@linkTblName+'.'+@fldName，
传了值后show出来。就明白什么问题了；
肯定赋值后，语法方面有问题（存储过程未写好);