我这里是SQLServer7~~怎么结果是正确的呢?? with AdoQuery1 do
begin
Close;
SQL.Clear;
SQL.Text := ' Select * from user_inf where parent_user_id like (select user_id from user_inf where user_name=+'#39+'qq'+#39+')+'+#39+'%'+#39;
Open;
end;
begin
Close;
SQL.Clear;
SQL.Text := ' Select * from user_inf where parent_user_id like (select user_id from user_inf where user_name=+'#39+'qq'+#39+')+'+#39+'%'+#39;
Open;
end;
这是我在isql里面写的语句:
declare @tmpstr varchar(10)
select @tmpstr=use_id from tmpusr where user_name='qq'
select @tmpstr=rtrim(@tmpstr)+'%'
select * from tmpusr where parent_user_id like @tmpstr