开发者

SSRS where-clause with value that contains an @

开发者 https://www.devze.com 2023-01-17 00:14 出处:网络
In SSRS 2005 we have a query in a dataset and the query filters on a certain value which happens to contain an @. Eg: select * from test where testfield = \'@LC\'. SSRS thinks this value s开发者_运维知

In SSRS 2005 we have a query in a dataset and the query filters on a certain value which happens to contain an @. Eg: select * from test where testfield = '@LC'. SSRS thinks this value s开发者_运维知识库hould be a parameter and treats it that way. How can configure my query so that SSRS treats it as a fixed value? Thanks!


Already tried with '[@]LC'

0

精彩评论

暂无评论...
验证码 换一张
取 消