正如上面老兄所说,有无数种解决方案,
比如asp中,可以select * from table where name like "+request.form()+""
pb,vb中,可以用sql="select * from table where name like "+ varibles+"%"
存储过程中
create proc test @var varchar(2)
as
exec "select * from table where name like "+ @var
比如asp中,可以select * from table where name like "+request.form()+""
pb,vb中,可以用sql="select * from table where name like "+ varibles+"%"
存储过程中
create proc test @var varchar(2)
as
exec "select * from table where name like "+ @var
where name like @a+'%'
我是用DELPHI编程的,在sql数据库中。Select * From Tablename Where Name Like '%' + :user + '%';当我有个新问题:
我事先不知道是那个关键字,就是说‘Name’是变量。我试过下面的方法:Select * From Tablename Where :Name Like :user;可是不行!
那该如何是好?