- 博客(4)
- 收藏
- 关注
转载 sql删除重复值
delete from people where peopleName in (select peopleName from people group by peopleName having count(peopleName) > 1) and peopleId not in (select min(peopleId) from people group by pe
2014-04-22 14:38:32 804
原创 查询数据库中存在指定字段的表
select 'select * into '+b.name+ '00 from ' +b.name+ ' where sch_id=''11022431111021330''' from syscolumns a,sys.objects b where a.name = 'sch_id' and a.id = b.object_id and b.type = 'U' and s
2014-04-04 17:29:45 764
原创 js根据按键传值跳转页面
function InputDic(tblName, cmpField, dicId, dicName, txtId, txtName) { var k = event.keyCode; //alert(k); var isValid = 0; if (k == 9 || k == 13) { return; } if
2014-04-04 15:24:02 2442
原创 js判断输入按键
var k=event.keyCode; if (k ==9 || k==13 ) return ;window.event.returnValue=false;
2014-04-04 15:17:29 700
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人