<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[LuckyPeter的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/luckypeter</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; luckypeter]]></copyright><item><title><![CDATA[哟哟，原来往虚拟空间导SQL2000和2005是这样做哒^.^]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/5035140</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/5035140</guid><author>luckypeter</author><pubDate>Fri, 18 Dec 2009 22:13:00 +0800</pubDate><description><![CDATA[哇，想当初这个问题困扰朱许久哎，当初可是因为丢主键和标识列的问题，搞的朱烦死啦，那可是一个个手工加上去的哎，手酸死。现在不用啦，原来导数据还要一点点技巧哒，虽然这也称不上技巧，写在这里喽，免得朱的脑瓜某天给不能用了。。 虚拟空间的数据库一般都是受限用户，像俺在开发机器上做，那数据库架构肯定都是dbo喽，登陆肯定是用sa喽。哇，这个在虚拟空间就行不通了，它会给新建一个用户，这个用户一般就访问]]></description><category></category></item><item><title><![CDATA[查看SQL Server中某数据库下每个表占用的空间大小]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4887108</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4887108</guid><author>luckypeter</author><pubDate>Fri, 27 Nov 2009 11:09:00 +0800</pubDate><description><![CDATA[很神奇，很伟大，朱很惊奇 if not exists (select * from dbo.sysobjects where id = object_id(N[dbo].[tablespaceinfo]) and OBJECTPROPERTY(id, NIsUserTable) = 1)create table tablespaceinfo --创建结果存储表(nameinfo v]]></description><category></category></item><item><title><![CDATA[SQL Server里一些未公开的扩展存储过程]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4318829</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4318829</guid><author>luckypeter</author><pubDate>Fri, 03 Jul 2009 14:07:00 +0800</pubDate><description><![CDATA[扩展存储过程（xp）是直接运行在SQL Server地址空间里的动态链接库，是通过使用SQL Server开放数据服务API（SQL Server Open Data Services API）开发的。我们可以像执行普通存储过程一样，在“查询分析器”里运行扩展存储过程。扩展存储过程被用于SQL Server的扩展功能，我们可以直接利用SQL Server附带的众多扩展存储过程，也可以用C或C++等]]></description><category></category></item><item><title><![CDATA[计算机端口]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4313266</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4313266</guid><author>luckypeter</author><pubDate>Wed, 01 Jul 2009 15:16:00 +0800</pubDate><description><![CDATA[怎样查看端口 一台服务器有大量的端口在使用，怎么来查看端口呢？有两种方式： 一种是利用系统内置的命令，一种是利用第三方端口扫描软件。 1.用“netstat －an”查看端口状态 在Windows 2000/XP中，可以在命令提示符下使用“netstat -an”查 看系统端口状态，可以列出系统正在开放的端口号及其状态． 2.用第三方端口扫描软件 第三方端口扫描软件有许多，界面虽然千差]]></description><category></category></item><item><title><![CDATA[sqlserver常用函数/存储过程/数据库角色 ]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4192816</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4192816</guid><author>luckypeter</author><pubDate>Sat, 16 May 2009 16:31:00 +0800</pubDate><description><![CDATA[/*日期函数*/DATEADD ( datepart , number, date ) --在向指定日期加上一段时间的基础上，返回新的 datetime 值。DATEDIFF ( datepart , startdate , enddate ) --返回跨两个指定日期的日期和时间边界数。DATENAME ( datepart , date )--返回代表指定日期的指定日期部分的字符串。DATEPA]]></description><category></category></item><item><title><![CDATA[HTTP协议的头信息详解]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4175788</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4175788</guid><author>luckypeter</author><pubDate>Wed, 13 May 2009 10:15:00 +0800</pubDate><description><![CDATA[HTTP（HyperTextTransferProtocol）是超文本传输协议的缩写，它用于传送WWW方式的数据，关于HTTP 协议的详细内容请参 考RFC2616。HTTP协议采用了请求/响应模型。客户端向服务器发送一个请求，请求头包含请求的方法、URI、协议版本、以及包含请求修饰符、客户 信息和内容的类似于MIME的消息结构。服务器以一个状态行作为响应，相应的内容包括消息协议的版本，成功或]]></description><category></category></item><item><title><![CDATA[JS判断浏览器类型]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4088944</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4088944</guid><author>luckypeter</author><pubDate>Sat, 18 Apr 2009 08:45:00 +0800</pubDate><description><![CDATA[      你知道世界上有多少种浏览器吗？除了我们熟知的IE, Firefox, Opera, Safari四大浏览器之外，世界上还有近百种浏览器。       几天前，浏览器家族有刚诞生了一位小王子，就是Google推出的Chrome浏览器。由于Chrome出生名门，尽管他还是个小家伙，没有人敢小看他。以后，咱们常说浏览器的“四大才子”就得改称为“五朵金花”了。       在网站前端开]]></description><category></category></item><item><title><![CDATA[批量替换ntext字段]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4036983</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4036983</guid><author>luckypeter</author><pubDate>Mon, 30 Mar 2009 20:24:00 +0800</pubDate><description><![CDATA[declare @ptr varbinary(16)declare @artId intdeclare @Position int,@len intset @len = datalength(老字符串)declare wux_Cursor scroll Cursorforselect textptr([字段名]),[key字段名] from [数据表名]for read onlyopen wu]]></description><category></category></item><item><title><![CDATA[FF下屏蔽右键、选择]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4019960</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4019960</guid><author>luckypeter</author><pubDate>Tue, 24 Mar 2009 13:36:00 +0800</pubDate><description><![CDATA[FF下屏蔽右键、选择  document.oncontextmenu=function(e){return   false;}     //-->               body   {       -moz-user-select : none;     }               asdfasdfsadfasdfasdfasdfasfsadfsdf        在I]]></description><category></category></item><item><title><![CDATA[marquee用法的详细解释]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4019538</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4019538</guid><author>luckypeter</author><pubDate>Tue, 24 Mar 2009 11:16:00 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[标准版本 禁止复制代码]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/4006665</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/4006665</guid><author>luckypeter</author><pubDate>Fri, 20 Mar 2009 10:10:00 +0800</pubDate><description><![CDATA[禁止复制代码function click() {alert(不能复制咯) }function click1() {if (event.button==2) {alert(欢迎来到我的BLOG！) }}function CtrlKeyDown(){if (event.ctrlKey) {alert(祝大家玩的开心！) }}document.onkeydown=CtrlKe]]></description><category></category></item><item><title><![CDATA[MIME类型]]></title><link>https://blog.youkuaiyun.com/luckypeter/article/details/3777221</link><guid>https://blog.youkuaiyun.com/luckypeter/article/details/3777221</guid><author>luckypeter</author><pubDate>Wed, 14 Jan 2009 16:43:00 +0800</pubDate><description><![CDATA[MIME类型大全application/vnd.lotus-1-2-33gp video/3gppaab application/x-authoware-binaam application/x-authoware-mapaas application/x-authoware-segai application/post******aif audio/x-aiffaifc audio/x-aiff]]></description><category></category></item><item><title><![CDATA[漂浮QQ]]></title><link>https://blog.youkuaiyun.com/LuckyPeter/article/details/3775430</link><guid>https://blog.youkuaiyun.com/LuckyPeter/article/details/3775430</guid><author>LuckyPeter</author><pubDate>Wed, 14 Jan 2009 12:56:00 +0800</pubDate><description><![CDATA[http://wpa.qq.com/pa?p=1:123456:1" alt="点击这里给我发消息">Xvar xPos = 20;var yPos = document.body.clientHeight;var step = 1;var delay = 30;                     var height = 0;                     var Hoffset]]></description><category></category></item><item><title><![CDATA[数据库操作类(源代码)]]></title><link>https://blog.youkuaiyun.com/LuckyPeter/article/details/1632646</link><guid>https://blog.youkuaiyun.com/LuckyPeter/article/details/1632646</guid><author>LuckyPeter</author><pubDate>Thu, 31 May 2007 12:50:00 +0800</pubDate><description><![CDATA[using System;using System.Data;using System.Data.SqlClient;namespace PeterZhu.DbOperator{    public class DbOperator : IDisposable    {        public DbOperator()        {        }        ///     ]]></description><category></category></item><item><title><![CDATA[实现DataGrid跨行(核心代码)]]></title><link>https://blog.youkuaiyun.com/LuckyPeter/article/details/1629340</link><guid>https://blog.youkuaiyun.com/LuckyPeter/article/details/1629340</guid><author>LuckyPeter</author><pubDate>Tue, 29 May 2007 13:01:00 +0800</pubDate><description><![CDATA[  private void spanRow(DataGrid dg,int GroupColumn,int compareColumn)   {    int i = 0;    int j = 0;    int rowSpan;    string strTemp = "";      for(i=0;i   {     rowSpan = 1;     strTemp = dg.Items]]></description><category></category></item><item><title><![CDATA[简单的发送邮件代码]]></title><link>https://blog.youkuaiyun.com/LuckyPeter/article/details/1618538</link><guid>https://blog.youkuaiyun.com/LuckyPeter/article/details/1618538</guid><author>LuckyPeter</author><pubDate>Mon, 21 May 2007 00:14:00 +0800</pubDate><description><![CDATA[  #region 邮件操作  ///   /// 获取MailMessage,邮件对象  ///   /// 发件人  /// 收件人  /// 邮件主题  /// 邮件正文  /// 邮件发送方式：html：以html方式发送；默认以text方式发送  /// 邮件优先级("0"：高优先级；"1"：普通优先级；"2"：低优先级；默认：普通优先级  ///   private MailMessa]]></description><category></category></item><item><title><![CDATA[Javascript弹出窗口详解]]></title><link>https://blog.youkuaiyun.com/LuckyPeter/article/details/1598542</link><guid>https://blog.youkuaiyun.com/LuckyPeter/article/details/1598542</guid><author>LuckyPeter</author><pubDate>Mon, 07 May 2007 00:06:00 +0800</pubDate><description><![CDATA[ 一、 弹出窗口的基本属性设置-------------------------------------------------------------------------------- window.open (page.html, newwindow, height=100, width=400, top=0, left=0, toolbar=no, menubar=no, sc]]></description><category></category></item></channel></rss>