摘要:
//重新加载js文件 function loadJs(file) { var head = $("head").remove("script[role='reload']"); $("<scri" + "pt>" + "</scr" + "ipt>").attr({ role: 'reload', src: file, type: 'text/javascript' }).appendTo(head); 阅读全文
摘要:
MIME类型大全application/vnd.lotus-1-2-33gp video/3gppaab application/x-authoware-binaam application/x-authoware-mapaas application/x-authoware-segai application/postscriptaif audio/x-aiffaifc audio/x-aiffaiff audio/x-aiffals audio/X-Alpha5amc application/x-mpegani application/octet-streamasc text/plaina 阅读全文
摘要:
if(EXISTS( SELECT * FROM sysobjects WHERE ID = OBJECT_ID('student'))) drop table studentcreate table student( stuid char(10) not null, stuname varchar(50) not null)insert into student values('050614001','张三')insert into student values('050614002','李四')insert i 阅读全文
摘要:
从服务器导出数据至txt文件(含用户名,密码)EXEC master..xp_cmdshell 'bcp "select * from ssKnitYY..orders" queryout "c:\DT.txt" -c -S"192.168.0.8" -U"sa" -P"000000"' “c:\DT.els” 将txt数据导入到数据库(含用户名,密码)EXEC master..xp_cmdshell 'bcp "YUAN_Test..orders" 阅读全文
摘要:
/// <summary> /// 验证位身份证 /// </summary> /// <param name="Id">身份证号码</param> /// <returns>是否真实身份证</returns> public static bool CheckIDCards(string Id) { int intLen = Id.Length; long n = 0; if (intLen == 18) { if (long.TryParse(Id.Remove(17), out n) == fals 阅读全文
摘要:
--创建 test 表 ,插入数据CREATE TABLE test(code varchar(50), [values] varchar(10),[count] int)INSERT test SELECT '001', 'aa',1UNION ALL SELECT '001', 'bb',2UNION ALL SELECT '002', 'aaa',4UNION ALL SELECT '002', 'bbb',5UNION ALL SELECT '002& 阅读全文