09 2008 档案

---sql server--删除重复记录
摘要:---sql server--删除重复记录 阅读全文

posted @ 2008-09-12 21:04 simhare 阅读(412) 评论(0) 推荐(0)

sql datetime 比较
摘要:Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select datediff(day,'2008-09-09','2008-9-7') Code Code highlighting produced by Actipro CodeH... 阅读全文

posted @ 2008-09-12 11:53 simhare 阅读(700) 评论(0) 推荐(0)

asp.net 导出到excel
摘要:public void ToExcel(System.Web.UI.Control ctl, string FileName) { HttpContext.Current.Response.Charset = "UTF-8"; HttpContext.Current.Response.ContentEncoding = System.Text.Encod... 阅读全文

posted @ 2008-09-11 23:14 simhare 阅读(951) 评论(1) 推荐(0)

asp导出数据到excel
摘要:http://www.xue5.com/itedu/200802/112337.html http://www.xue5.com/itedu/200802/112338.html 阅读全文

posted @ 2008-09-11 23:09 simhare 阅读(151) 评论(0) 推荐(0)

常用sql语句
摘要:说明:复制表(只复制结构,源表名:a 新表名:b) SQL: select * into b from a where 11 说明:拷贝表(拷贝数据,源表名:a 目标表名:b) SQL: insert into b(a, b, c) select d,e,f from b; ++++++++ 说明:日程安排提前五分钟提醒 SQL: sele... 阅读全文

posted @ 2008-09-11 23:07 simhare 阅读(141) 评论(0) 推荐(0)

BCP从sql server 导出 excel
摘要:Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->1 exec master..xp_cmdshell 'bcp "select top 1 * from Northwind..Customers" queryout c:\Temp.xls -... 阅读全文

posted @ 2008-09-11 22:30 simhare 阅读(516) 评论(0) 推荐(0)

Page_Load 不能断点
摘要:Debug="true" AutoEventWireup="true" 这两项要设为true,有时候这两项有一个为false就不能进page_load 阅读全文

posted @ 2008-09-04 13:29 simhare 阅读(216) 评论(0) 推荐(0)

导航