<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[li_hy2002]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/li_hy2002</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; li_hy2002]]></copyright><item><title><![CDATA[sqlserver2005 同步的问题总结]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84211070</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84211070</guid><author>li_hy2002</author><pubDate>Sat, 28 Apr 2012 16:09:17 +0800</pubDate><description><![CDATA[发布流程：http://www.cnblogs.com/zqwuwei/articles/969467.html
 
问题
1、SQL Server 复制需要有实际的服务器名称才能连接到服务器。不支持通过服务器别名、IP 地址或任何其他备用名称进行连接。请指定实际的服务器名称“xxxx”。 (Replication.Utilities)
原因：修改过计算机名称
解决：先用 sp_drop...]]></description><category></category></item><item><title><![CDATA[SQL Server 2005 XML 操作总结（转）]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84187979</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84187979</guid><author>li_hy2002</author><pubDate>Tue, 17 Apr 2012 15:18:57 +0800</pubDate><description><![CDATA[转载网上的，方便以后查找
 

后续文章中的操作全部都针对该示例

 


declare @data xmlset @data='&amp;lt;bookstore&amp;gt;&amp;lt;book category=&quot;COOKING&quot; &amp;gt;&amp;lt;title lang=&quot;en&quot;&amp;gt;Everyday Italian&amp;lt;/title&amp;gt;&amp;lt;author&amp;gt;Giada De ]]></description><category></category></item><item><title><![CDATA[sqlservice2005 xml字段查询的空值问题]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84187967</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84187967</guid><author>li_hy2002</author><pubDate>Tue, 17 Apr 2012 15:01:50 +0800</pubDate><description><![CDATA[在对sqlserver2005的xml字段进行查询时发现：查询结果如果为空，显示的速度会很慢
例如：


select* from table 
where fbfw.exist('/Root/Person[.=''xxx'' and @checked=\&quot;0\&quot;]')=1 

 或者


select * from table
where fbfw.value('(/Root/...]]></description><category></category></item><item><title><![CDATA[php 防sql注入]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84159943</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84159943</guid><author>li_hy2002</author><pubDate>Tue, 28 Feb 2012 10:58:56 +0800</pubDate><description><![CDATA[1、打开 php.ini 中的 magic_quotes_gpc 选项，将提交的变量中所有的 '(单引号)、&quot;(双号号)、\(反斜线)、空白字符，都为在前面自动加上 \
 
2、在$_get[]和$_post[]时使用htmlspecialchars()函数转换特殊字符为HTML字符编码(mysql_escape_string()函数也可以转移字符串)
 
3、关闭php.ini 中的 d...]]></description><category></category></item><item><title><![CDATA[php中使用session]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84159936</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84159936</guid><author>li_hy2002</author><pubDate>Tue, 28 Feb 2012 10:51:51 +0800</pubDate><description><![CDATA[在登录页面新建session


session_start(); 
$_SESSION['username'] = $username;

 在需要验证的页面使用


//验证session
session_start();
//session中是否存在username并且session是否过期
if(!isset($_SESSION[&quot;username&quot;])|| time(...]]></description><category></category></item><item><title><![CDATA[flash的几个问题]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84159561</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84159561</guid><author>li_hy2002</author><pubDate>Mon, 27 Feb 2012 16:59:54 +0800</pubDate><description><![CDATA[

flash背景透明
火狐实现Flash背景透明，需要在embed标签中，添加属性wmode=&quot;Transparent&quot;
而IE则需要在object标签中间，添加&amp;lt;param name=&quot;wmode&quot; value=&quot;Transparent&quot; /&amp;gt;

 
flash在最底层显示
在embed标签中，添加属性wmode=&quot;opaque&quot;
 ...]]></description><category></category></item><item><title><![CDATA[vb WebBrowser控件]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84159560</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84159560</guid><author>li_hy2002</author><pubDate>Mon, 27 Feb 2012 16:58:08 +0800</pubDate><description><![CDATA[公司要做一个网站发布器的，功能很简单，就是到固定的地址去取出最新的网站地址，然后自动打开网页。所有决定用vb做了。代码很简单
Option Explicit
Private Declare Sub Sleep Lib &quot;kernel32 &quot; (ByVal dwMilliseconds As Long)
Private Sub Form_Load()
    WebBrowser1.Navi...]]></description><category></category></item><item><title><![CDATA[开博了]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84154005</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84154005</guid><author>li_hy2002</author><pubDate>Thu, 16 Feb 2012 11:26:54 +0800</pubDate><description><![CDATA[工作中遇到的问题越来越多，统一记录下来，方便查找]]></description><category></category></item><item><title><![CDATA[mysql数据库主从同步]]></title><link>https://blog.youkuaiyun.com/li_hy2002/article/details/84153992</link><guid>https://blog.youkuaiyun.com/li_hy2002/article/details/84153992</guid><author>li_hy2002</author><pubDate>Thu, 16 Feb 2012 11:12:28 +0800</pubDate><description><![CDATA[花了2天，google了无数才配出来，见笑。

[b]环境[/b]
主机：freeBSD8.2 + myslq5.1 ip：192.168.1.240（vm）
从机：freeBSD8.2 + mysql5.1 ip：192.168.1.121（vm）



[b]主机设置：[/b]
创建从机访问帐号
flush privileges;（防止出现ERROR 1290（HY000）...]]></description><category></category></item></channel></rss>