要sql語句中加入執行變量

  set   @sql=N'select @oogoodscount=SUM(TStoreDecStoreD.fResCount) from  TStoreDecStoreD
   INNER JOIN TStoreDecStoreM ON (TStoreDecStoreD.fStoreDecStoreMID = TStoreDecStoreM.fStoreDecStoreMID)
   WHERE  TStoreDecStoreM.fBillDate between '''+@ibdate+''' and '''+@iedate+''' and TStoreDecStoreD.fResID='+ cast(@ResID as varchar) 
exec   sp_executesql   @sql,N'@oogoodscount  float  output',@oogoodscount   output