还没解决完搜索存储过程
存储过程为：
ALTER proc test1
@sale_name varchar(50),
@quyu varchar(50),
@subxingzhi_name varchar(50),
@developer_name varchar(50),
@room_type int,
@chaoxiang varchar(50),
@area float,
@price float,
@sql varchar(8000) output
as
set @sql= 'select distinct * from sale
a,householdmodel b,developers c ,subxingzhi d
where a.sale_id=b.sale_id and a.developer_id=c.developer_id and a.subxingzhi_id=d.subxingzhi_id '
if @sale_name <> '1 '
begin
set @sql=@sql+ ' and a.sale_name= ' ' '+@sale_name+ ' ' ' '
end
if @quyu <> '1 '
begin
set @sql=@sql+ ' and a.quyu= ' ' '+@quyu+ ' ' ' '
end
if @subxingzhi_name <> '1 '
begin
set @sql=@sql+ ' and d.subxingzhi_name= ' ' '+@subxingzhi_name+ ' ' ' '
end
if @developer_name <> '1 '
begin
set @sql=@sql+ ' and c.developer_name= ' ' '+@developer_name+ ' ' ' '
end
if @room_type <> '1 '
begin
set @sql=@sql+ ' and b.room_type= '+cast(@room_type as varchar)
end
if @chaoxiang <> '1 '
begin
set @sql=@sql+ ' and b.chaoxiang= ' ' '+@chaoxiang+ ' ' ' '
end
if @area <> '1 '
begin
set @sql=@sql+ ' and a.area= '+cast(@area as varchar)
end
if @price <> '1 '
begin
set @sql=@sql+ ' and a.price= '+cast(@price as varchar)
end
print @sql
exec (@sql)
执行为：
exec test1 'aa ', 'b ', '1 ', '1 ', '1 ', '1 ', '1 ', '1 ',2
为什么返回的为空呢?
aa 和b 表中都的数据
[解决办法]
在你的消息那看看在结果是看不到的
