ASP如何实现通过一个员工编号查出他的所有记录，数据库是MSSQL

select * from table where 员工编号=传回的编号

假设表名为：YUANGONG
标号为：BIANHAO
条件（编号）输入框为：BIAOHAO
查询语句为：
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from YUANGONG where BIANHAO like '%"&trim(request("BIANHAO"))&"%'order by id desc"
rs.open sql,conn ,1,1
if rs.recordcount<>0 then
do while not rs.eof
%>
................
<%
rs.movenext
loop
end if
%>
................
<input name="BIANHAO" type="text" id="IANHAO" size="12" maxlength="11" onMouseOver="this.focus();">
................

楼上已经很详细了，俺就懒得说了哦