SELECT sDiff05 AS sRawGMWT
FROM dbo.mmFPInDtl WITH(NOLOCK)
WHERE sMaterialLot=:sMaterialLot后面的sMaterialLot=:sMaterialLot中的“=:”是什么意思
FROM dbo.mmFPInDtl WITH(NOLOCK)
WHERE sMaterialLot=:sMaterialLot后面的sMaterialLot=:sMaterialLot中的“=:”是什么意思
前台程序的sql 代码
if(条件= 值1:?值2)
你代码里面sMaterialLot='123456'当程序执行的时候就是这样SELECT sDiff05 AS sRawGMWT
FROM dbo.mmFPInDtl WITH(NOLOCK)
WHERE sMaterialLot='123456'
SELECT sDiff05 AS sRawGMWT
FROM dbo.mmFPInDtl WITH(NOLOCK)
WHERE sMaterialLot=:sMaterialLot
程序后面有类似语句sMaterialLot=""