添加sql WHERE语句以选择数据库中的新ID:s (asp / sql)

<%
' 创建数据库连接对象
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "数据库连接字符串"

' 创建数据库命令对象
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn

' 设置SQL查询语句
sql = "SELECT * FROM 表名 WHERE ID > 100"

' 设置命令对象的SQL语句
cmd.CommandText = sql

' 执行查询并获取结果集
Set rs = cmd.Execute

' 遍历结果集并输出数据
While Not rs.EOF
    Response.Write rs("ID") & "<br>"
    rs.MoveNext
Wend

' 释放资源
rs.Close
Set rs = Nothing
Set cmd = Nothing
conn.Close
Set conn = Nothing
%>