返回首页

我有一列说TypeOfManager哪里会有像
NBSP项;

TypeOfManager -----------------

关系的销售
S

R在这种情况下,我想治疗"R"关系和"S"为销售。这将是在SQL Server查询的语法。

回答

评论会员:游客 时间:2012/02/06
迈赫迪吴拉姆:只要他们是相同的:codeprelang="SQL"spanclass="code-keyword"update/spantablenamespanclass="code-keyword"set/spanTypeOfManager=spanclass="code-string"'/spanspanclass="code-string"Relation'/spanspanclass="code-keyword"where/spanTypeOfManager=spanclass="code-string"'/spanspanclass="code-string"R'/spanspanclass="code-keyword"GO/spanspanclass="code-keyword"update/spantablenamespanclass="code-keyword"set/spanTypeOfManager=spanclass="code-string"'/spanspanclass="code-string"Sales'/spanspanclass="code-keyword"where/spanTypeOfManager=spanclass="code-string"'/spanspanclass="code-string"S'/spanspanclass="code-keyword"GO/span/pre/code
palraj001
评论会员:游客 时间:2012/02/06
尝试用查询{C}的问候,PAL