雨-夜

摘要： //校验是否全由数字组成 function isDigit(s) { var patrn=/^[0-9]{1,20}$/; if (!patrn.exec(s)) return false return true }//校验登录名：只能输入5-20个以字母开头、可带数字、“_”、“.”的字串 function isRegisterUserName(s) { var patrn=/^[a-zA-Z]{1}([a-zA-Z0-9]|[._]){4,19}$/; if (!patrn.exec(s)) return false return true }//校验用户姓名：只能输入1-30... 阅读全文

摘要： INSERT INTO excel SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0' ,'Excel 5.0;HDR=YES;DATABASE=D:\Book1.xls',无公式$)//开启Ad Hoc Distributed Queries EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE with override GO EXEC sp_configure 'Ad Hoc Distributed Queries&# 阅读全文

摘要： delete from companyepe where companyno in (select companyno from companyepe group by companyno having count(companyno) > 1)and companyid not in (select min(companyid) from companyepe group by companyno having count(companyno )>1) 阅读全文

摘要： FROM t_customerWHERE (Customer_number IN (SELECT Customer_number FROM t_customer AS companyepe_2 GROUP BY Customer_number HAVING (COUNT(Customer_number) > 1))) 阅读全文