Question

SQL SERVER 存储过程中在使用查询的时候提示错误

DECLARE @T_CityName VARCHAR (30)
set @T_CityName = select CityName from T_basic_City where CityName = @In_SenderCity IF(@T_CityName = @In_SenderCity)
begin
set @m_SendCityName = @T_CityName
end
提示:关键字 'select' 附近有语法错误。

Answer 1

set @T_CityName = select CityName from T_basic_City where CityName = @In_SenderCity IF(@T_CityName = @In_SenderCity)
换成
select @T_CityName = CityName from T_basic_City where CityName = @In_SenderCity
试试