select * from table1 where name like '%'+@params+'%'
哪你在存储过程中写不就行了吗? create procedure proc1 @name_p varchar(10) as declare @sqlstr char(500) set @sqlstr='select * from table1 where [name] like '%'+name_p+'%' exec (@sqlstr)
create procedure myproc (myName varchar(20))as declare @sqltext varchar(200) begin transaction mytans select @sqltext = 'select * from tablename where colname like ''%'+myName+'%''' exec(@sqltext)if @@error = 0 commit transaction mytans else rollback transaction mytrans
ss=trim(edit1.text); with query1 do begin close; sql.Clear; sql.Add('select * from studDB where Sno like :Sno'); params.ParamValues['Sno']:=ss+'%'; open; end;
在ibconsole中,第一和第二回答的好象不对呢,@不能定义呢
ss:=trim(edit1.text); with query1 do begin close; sql.Clear; sql.Add('select * from studDB where Sno like :Sno'); params.ParamValues['Sno']:=ss+'%'; open; end;
create procedure proc1 @name_p varchar(10)
as
declare @sqlstr char(500)
set @sqlstr='select * from table1 where [name] like '%'+name_p+'%'
exec (@sqlstr)
declare @sqltext varchar(200)
begin transaction mytans
select @sqltext = 'select * from tablename where colname like ''%'+myName+'%'''
exec(@sqltext)if @@error = 0
commit transaction mytans
else
rollback transaction mytrans
with query1 do
begin
close;
sql.Clear;
sql.Add('select * from studDB where Sno like :Sno');
params.ParamValues['Sno']:=ss+'%';
open;
end;
with query1 do
begin
close;
sql.Clear;
sql.Add('select * from studDB where Sno like :Sno');
params.ParamValues['Sno']:=ss+'%';
open;
end;