可以的: declare @x varchar(10) declare @y varchar(10)select @x='a',@y='b'SELECT * FROM 你的表 WHERE column1 LIKE @x+@y+'%'
declare @x varchar(10) declare @y varchar(10) select @x='xxx' select @y='xxx' select * from you_table where filed like @x+@y+'%'
在delphi中下面第6行中a,b 为变量,这样写有没有错误 with ADOQuery1 do begin close; sql.Clear; sql.Add('Select sth,stnr,xxa,xxb,xxc,xxd,sjbh from dxxz '); sql.Add(' where sjbh like a+b+'%'); sql.Add(' order by sth'); open; end;
这句错了: sql.Add(' where sjbh like a+b+'%');应该改为: sql.Add(' where sjbh like '''+a+b+'%''');
with ADOQuery1 do begin close; sql.Clear; sql.Add('Select sth,stnr,xxa,xxb,xxc,xxd,sjbh from dxxz '); sql.Add(' where sjbh like '''+a+b+'%'''); sql.Add(' order by sth'); open; end;
declare @x varchar(10)
declare @y varchar(10)select @x='a',@y='b'SELECT * FROM 你的表 WHERE column1 LIKE @x+@y+'%'
declare @y varchar(10)
select @x='xxx'
select @y='xxx'
select * from you_table where filed like @x+@y+'%'
with ADOQuery1 do
begin
close;
sql.Clear;
sql.Add('Select sth,stnr,xxa,xxb,xxc,xxd,sjbh from dxxz ');
sql.Add(' where sjbh like a+b+'%');
sql.Add(' order by sth');
open;
end;
sql.Add(' where sjbh like a+b+'%');应该改为:
sql.Add(' where sjbh like '''+a+b+'%''');
begin
close;
sql.Clear;
sql.Add('Select sth,stnr,xxa,xxb,xxc,xxd,sjbh from dxxz ');
sql.Add(' where sjbh like '''+a+b+'%''');
sql.Add(' order by sth');
open;
end;