!!!!!! Why can't dynamic SQL statements execute ????

lainomi

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


Why can't it be executed? What should be done?

abomination

declare @g_Condi2 varchar(1000)
set @g_Condi2 ='and State = ``Incumbent'''
exec('select name,sex,address,photo,state from t_name
where name=``Zhang San'''+@G_Condi2+'');

stevevai

Agree upstairs

lainomi

I also do this withabomination, but it is called through a stored procedure and cannot return the query result set to the caller.

endman

declare @g_Condi2 varchar(1000)
set @g_Condi2 ='and State = ``Incumbent'''
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=``Zhang San'''+@G_Condi2+'');

select * from #test

lainomi

Did not get the desired answer.