if exists(select *from sysobjects where name='getcompanymap')
drop proc getcompanymap
go
create proc getcompanymap
@areaid int,
@CustTradePtr int,
@CustTrade1 int,
@CustTrade2 int
as
declare @sql varchar(2000)
set @sql='select custname,url,didu,mobile,addr from company where 1=1'
if @CustTradePtr<>0
set @sql=@sql+' and CustTradePtr='+convert(varchar(20),@CustTradePtr)
if @CustTrade1<>0
set @sql=@sql+' and CustTrade1='+convert(varchar(20),@CustTrade1)
if @CustTrade2<>0
set @sql=@sql+' and CustTrade2='+convert(varchar(20),@CustTrade2)
set @sql=@sql+' and areaid='+convert(varchar(20),@areaid)
print @sql

------解决方案--------------------
exec (@sql)，加括号


------解决方案--------------------
你的存储过程中，exec @sql改写成execute (@sql)，加括号
探讨

我是这样写的

SQL code


if exists(select *from  sysobjects where name='getcompanymap')
drop proc getcompanymap
go
create proc getcompanymap
@areaid int,
@CustTradePtr int,
@CustTrade1 int,
@Cus……


------解决方案--------------------
declare @sql varchar(2000)  
@sql是字符串，参数是int，不能直接 “+”哈，用convert转换一下就好了