如何在sql语句中添加变量，注：在查询分析器内！

@@为全局变量，declare @mm char(10)

set @mm='000'

select * from member where menberNo like '%'+@mm+'%'

楼上的有点笔误

s.open

"select

*

from

gqxx

where

yz=1

and

gq='"

&

bianliang

&

"'

order

by

id

desc",

conn,

1,

1

注意

gq='

，后面有个单引号。后面的

'

order

也是。

---