我连接到sql数据库后,如何查找数据(查找唯一的数据,也就是说把重复的去掉)
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim selStr As String
selStr = "select unique founds.year from founds"
cnn.Open "Driver={sql队server};server=localhost;uid=sa;pwd=sa;database=Example"
rs.Open selStr, cnn
i = 0
Do While Not rs.EOF
i = i + 1
rs.MoveNext
Loop
ReDim value(i - 1)
rs.MoveFirst
i = 0
Do While Not rs.EOF
value(i) = rs!year
i = i + 1
rs.MoveNext
Loop
rs.Close
cnn.Close
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim selStr As String
selStr = "select unique founds.year from founds"
cnn.Open "Driver={sql队server};server=localhost;uid=sa;pwd=sa;database=Example"
rs.Open selStr, cnn
i = 0
Do While Not rs.EOF
i = i + 1
rs.MoveNext
Loop
ReDim value(i - 1)
rs.MoveFirst
i = 0
Do While Not rs.EOF
value(i) = rs!year
i = i + 1
rs.MoveNext
Loop
rs.Close
cnn.Close
Dim rs As New ADODB.Recordset
Dim selStr As String
dim i as integerselStr = "select distinct year from founds"
cnn.Open "Driver={sqlserver};server=localhost;uid=sa;pwd=sa;database=Example"rs.CursorLocation =adUseClient
rs.Open selStr, cnn
ReDim value(rs.recordcount)
for i=0 to rs.recordcount
value(i) = rs!year
rs.MoveNext
Loop
rs.Close
cnn.Close
sqlstr = "select distinct year from founds where 条件"