declare @s varchar(20) set @s=s2 select * from tb where a1=@s
dim count as integer count = 0 set cnn = new adodb.conncetion set rs = new adodb.recordset cnn.open"连接数据库语句" rs.open"select a1 from a where a1 = 's2'" ,cnn do while rs.eof =false count=rs.Fields(a1) rs.movenext loop rs.close
strsql = "select * from tb where a1='" & 变量 & "'
工程->引用Microsoft Active Data Object 2.X dim con as new adodb.connection con.open "provider=sqloledb.1;initial catalog = dbname;integrated security =sspi";dim rs as new adodb.recordset rs.cursorlocation = adclient;rs.open "select top 1 s2 from tb",con,1,3dim 变量 as string变量 = rs.fields("s2").valuers.close con.close
set @s=s2
select * from tb where a1=@s
dim count as integer
count = 0
set cnn = new adodb.conncetion
set rs = new adodb.recordset
cnn.open"连接数据库语句"
rs.open"select a1 from a where a1 = 's2'" ,cnn
do while rs.eof =false
count=rs.Fields(a1)
rs.movenext
loop
rs.close
dim con as new adodb.connection
con.open "provider=sqloledb.1;initial catalog = dbname;integrated security =sspi";dim rs as new adodb.recordset
rs.cursorlocation = adclient;rs.open "select top 1 s2 from tb",con,1,3dim 变量 as string变量 = rs.fields("s2").valuers.close
con.close