这句SQL 语句错在那里?
select `gId` as 客户编号,`gName` as 客户名称,`gLankman` as 联系人,`gType` as 客户类别,`gRegion` as 所在地区,`gSource` as 客户来源,`gFollow` as 跟进程度,`gValue` as 价值等级 from tb_client where `gName` like @'Microsoft Visual Studio' order by Id
本文分析了一条包含错误的SQL语句,详细解释了错误的原因,并提供了正确的写法。涉及的关键概念包括SQL语法、参数引用及字符串匹配。
这句SQL 语句错在那里?
select `gId` as 客户编号,`gName` as 客户名称,`gLankman` as 联系人,`gType` as 客户类别,`gRegion` as 所在地区,`gSource` as 客户来源,`gFollow` as 跟进程度,`gValue` as 价值等级 from tb_client where `gName` like @'Microsoft Visual Studio' order by Id