SQL Server,可以像变量一样使用T-SQL运算符吗?或类似的东西 [英] SQL Server, Can a T-SQL operator be used like a variable ? Or something like that
本文介绍了SQL Server,可以像变量一样使用T-SQL运算符吗?或类似的东西的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想做的就是这样
DECLARE @operator nvarchar;
SET @operator = 'AND'
SELECT * FROM MyTable
WHERE first_column = "1" @operator second_columnt = "2"
有没有办法实现像这样的逻辑?
is there a way to implement a logic like that one ?
推荐答案
您可以使用动态sql来做到这一点:
You can do that using dynamic sql:
declare @query varchar(max)
set @query = 'select * from MyTable where first_column = ''1'' ' +
@operator + ' second_column = ''2'''
exec (@query)
有时候,语句逻辑就足够了,例如:
Sometimes, where statement logic is sufficient, like:
select *
from MyTable
where (operator = 'AND' and first_column = '1' and second_column = '2')
or (operator = 'OR' and (first_column = '1' or second_column = '2'))
这篇关于SQL Server,可以像变量一样使用T-SQL运算符吗?或类似的东西的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文