sql - 在预期条件的上下文中指定的非 bool 类型的表达式，接近 '@orderwhere'

Question

为什么以下语法会产生错误“An expression of non-boolean type specified in a context where a condition is expected, near '@orderwhere'”

use orders
declare @orderwhere varchar(5000)
set @orderwhere = 'order_status.step = 1'
select order_status.order_id
from order_status
where @orderwhere

Answer 1

您的查询部分不能是动态的。它必须是全有或全无。然后使用 EXEC()运行您的动态查询

exec('select order_status.order_id
      from order_status
      where ' + @orderwhere)