03 2007 档案
摘要：Sql Server / Oracle--返回第一行数据SELECT TOP 1 * FROM TableName / SELECT * FROM TableName WHERE ROWNUM=1--返回前五行数据SELECT TOP 5 * FROM TableName / SELECT * FROM TableName WHERE ROWNUM 0
阅读全文
摘要：save resources节省资源 advocate the management of resources倡导资源管理 guide, advance and supervise the implementation of the plan指导，促进和监督计划实施 hold consultation meetings举办咨询会 put forward valuable suggestions提出...
阅读全文
摘要：function test(e) { var tt = e.parentElement.parentElement.cells[1].innerText; //11 alert(tt); var _array = e.parentElement.parentElement.cells[1].children; for(var i=0;i10 11...
阅读全文
摘要：WEB页面导出为EXCEL文档的方法 单元格A 单元格A 单元格A 单元格A 单元格合并行A 单元格B 单元格B 单元格B 单元格B 单元格合并行B
阅读全文
摘要：Response.Clear(); Response.Buffer = true; Response.Charset = "gb2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode("中文名称") + ".xls"); //Response.Cont...
阅读全文
摘要：f1 f2 f3 --------------------- 001 01 100 002 01 200 001 02 300 002 02 400 003 01 500 004 02 600若想显示为以下格式，应如果写 SQL语句？ f1 f2 f3 --------------------- 00...
阅读全文
摘要：1. CURSORDECLARE Role_Cursor CURSOR FOR SELECT RoleName FROM SYS_RRole WHERE ID IN (SELECT RoleID FROM SYS_RAccountRole WHERE AccountID = @AccountID) OPEN Role_Cursor FETCH NEXT FROM Role_...
阅读全文
