!!!!!!动态条件判断SQL语句为什么不能执行????

lainomi

declare @g_Condi2 varchar(1000)
set @g_Condi2= 'and State = ''在职'''
select  name,sex,address,photo,state from t_name
where name='张三'+@G_Condi2


为什么不能执行?应该怎样解决.

abomination

declare @g_Condi2 varchar(1000)
set @g_Condi2= 'and State = ''在职'''
exec('select name,sex,address,photo,state from t_name
where name=''张三'''+@G_Condi2+'');

stevevai

同意楼上

lainomi

我也是abomination这样做,但通过存储过程调用,不能返回查询结果集给调用方.

endman

declare @g_Condi2 varchar(1000)
set @g_Condi2= 'and State = ''在职'''
create table #test
(name varchar(10),
sex bit,
address varchar(100),
photo image,
state bit
)

insert into #test
exec('select name,sex,address,photo,state from t_name
where name=''张三'''+@G_Condi2+'');

select * from #test

lainomi

没得到想要的答案。