对此的解释 [英] Explanation for this

问题描述

设置@ Gender = case当@ Gender =''然后''else'和c.Customer_gender喜欢'''+ @ Gender +''''结束这个'''+ @ gender +''的含义是什么'

set @Gender=case when @Gender='' then '' else ' and c.Customer_gender like '''+@Gender+'''' end in this what is the meaning of '''+@gender+'''

推荐答案

看起来有人在运行中创建一个SQL条件，并且想法是最终的sql语句将包含类似
的条件

It looks like someone creates a SQL condition on-the-fly and the idea is that the final sql statement will contain a condition like the

...  AND c.Customer LIKE 'VariableValueGoesHere' ...

两个撇号将转换为单个撇号，第三个停止/启动字符串文字。

The two apostrophes will translate to a single apostrophe and the third ones stops/starts the string literal.

这篇关于对此的解释的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！