请问 X和Y可以分别作变量吧

[seima]

SELECT *
FROM table_name1
WHERE column1 LIKE 'xy%'



请问 X和Y可以分别作为变量吧?

[zjcxc]

可以的:
declare @x varchar(10)
declare @y varchar(10)

select @x='a',@y='b'

SELECT * FROM 你的表 WHERE column1 LIKE @x+@y+'%'

[benxie]

declare @x varchar(10)
declare @y varchar(10)
select @x='xxx'
select @y='xxx'
select * from you_table where filed like @x+@y+'%'

[seima]

在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;

[zjcxc]

这句错了:
sql.Add(' where sjbh like a+b+'%');

应该改为:
sql.Add(' where sjbh like '''+a+b+'%''');

[pengdali]

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;

[perwang]

declare @x varchar(10)
declare @y varchar(10)

SELECT *
FROM table_name1
WHERE column1 LIKE @x+@y+'%'

[dafu71]

sql.Add(' where sjbh like '''+ a + b + '%''');