when Charindex(username,ClientName) =0 and Charindex(ContactName,ClientName) >0 then 't3'
when (Charindex(username,ClientName) =0 and Charindex(ContactName,ClientName)) >0 then 't3'
以上两个语句是否等价?
还是与下面这个语句等价
when Charindex(username,ClientName) =0 and(Charindex(ContactName,ClientName) >0 ) then 't3'
when (Charindex(username,ClientName) =0 and Charindex(ContactName,ClientName)) >0 then 't3'
以上两个语句是否等价?
还是与下面这个语句等价
when Charindex(username,ClientName) =0 and(Charindex(ContactName,ClientName) >0 ) then 't3'
when Charindex(username,ClientName) =0 and Charindex(ContactName,ClientName) >0 then 't3' --#1和#3是一个意思
when (Charindex(username,ClientName) =0 and Charindex(ContactName,ClientName)) >0 then 't3' --#2括号内的语法错误
when Charindex(username,ClientName) =0 and (Charindex(ContactName,ClientName) >0) then 't3' --#1和#3是一个意思,只是#3多了个括号,无所谓
end