摘要: SQL Server

ODBC

Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"

Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
... ...阅读全文

摘要: "select top 10 a.lsh from account as a where a.lsh not in (select top " + page + " b.lsh from account as b)"
其中 top 10 为我们需要分页的页数， page 为启始的记录数；如：我们现在需要 1-10条的记录 page=0，需要11-20的记录 page=10
... ...阅读全文