摘要: 查询一个表(Per_Employee )的字段记录不在另一个表(con_contract)中 条件:Per_Employee 的字段key的值不在con_contract表中 最原始的写法: SELECT p.* FROM Per_Employee p WHERE p.employeeid NOT IN (SELECT c.employeeid FROM con_contract c where c.employeeid = p.employeeid )解决的方法SELECT p.* FROM per_employee p LEFT JOIN con_contract c O... 阅读全文
posted @ 2012-06-28 13:46 _____ピ记忆的悴片ミ 阅读(215) 评论(0) 推荐(0)
摘要: 网上有多中的做法,个人是根据网上查询的资料,整理成的<div style="position: relative"><span style="margin-left: 100px; overflow: hidden; width: 18px"><asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList 阅读全文
posted @ 2012-06-26 17:17 _____ピ记忆的悴片ミ 阅读(384) 评论(0) 推荐(0)