<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cbting的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cbting</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cbting]]></copyright><item><title><![CDATA[update from ]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83736742</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83736742</guid><author>cbting</author><pubDate>Mon, 25 Oct 2010 13:59:52 +0800</pubDate><description><![CDATA[
update一般用来更新一个表中的字段。

update from可以用表1的B字段的值去更新表2的B字段，例如：

update test2 set b=y.b from test2 x,test1 y where x.a=b.a 

]]></description><category></category></item><item><title><![CDATA[http://www.niunan.org/show.php?id=265]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83608774</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83608774</guid><author>cbting</author><pubDate>Mon, 03 May 2010 11:07:42 +0800</pubDate><description><![CDATA[create PROCEDURE [dbo].[proc_ShowPage]  
@tblName   varchar(255),       -- 表名  
@strGetFields varchar(1000) = '*', -- 需要返回的列，默认*  
@strOrder varchar(255)='',      -- 排序的字段名，必填  
@strOrderType varc...]]></description><category></category></item><item><title><![CDATA[mssql有用的函数]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83607728</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83607728</guid><author>cbting</author><pubDate>Thu, 29 Apr 2010 21:21:31 +0800</pubDate><description><![CDATA[随机数;
select right(newid(),10)
绝对值(也就是没有出现负数)
select abs(-0.99)  
比如 1.000003 他就是取2 对于- 1.000003 就取-1
select ceiling(num) from category
比如 1.000003 他就是取1 对于- 1.000003 就取-2
select floor(num) from...]]></description><category></category></item><item><title><![CDATA[post传值 and get传值]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83461978</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83461978</guid><author>cbting</author><pubDate>Sat, 19 Sep 2009 15:16:48 +0800</pubDate><description><![CDATA[&amp;lt;title&amp;gt;登录页面&amp;lt;/title&amp;gt;&amp;lt;/head&amp;gt;&amp;lt;body&amp;gt;    &amp;lt;form id=&quot;form1&quot; runat=&quot;server&quot; method=&quot;post&quot; action=&quot;index.aspx&quot;&amp;gt;    &amp;lt;div&amp;gt;        &amp;lt;asp:T]]></description><category></category></item><item><title><![CDATA[http://sofewater-in-sky.javaeye.com/blog/267137]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83453107</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83453107</guid><author>cbting</author><pubDate>Sun, 23 Aug 2009 14:51:30 +0800</pubDate><description><![CDATA[--返回表的字段名称 select name from syscolumns where id=object_id('jobs') --刚看到的.新建一个与a表一样的空的b表 select * into b from a where 1&amp;lt;&amp;gt;1 一些不错的sql语句，自己根据需要收藏吧，分给多点哦:) 1、说明：复制表(只复制结构,源表名：a 新表名：b) (Access可用) 法一：s...]]></description><category></category></item><item><title><![CDATA[GridView背景隔行换色和鼠标移上去换色?]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83452344</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83452344</guid><author>cbting</author><pubDate>Thu, 20 Aug 2009 23:25:16 +0800</pubDate><description><![CDATA[鼠标移上去换色?用jquery去实现;
 
$(&quot;.delete_link&quot;).parent().parent().mouseover(function(){                   $(this).css(&quot;backgroundColor&quot;,&quot;#cccccc&quot;);                    }) .mouseout(function(){               ...]]></description><category></category></item><item><title><![CDATA[execl导入用sql导入到数据库中!!!!!]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83451840</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83451840</guid><author>cbting</author><pubDate>Wed, 19 Aug 2009 20:00:15 +0800</pubDate><description><![CDATA[INSERT INTO mobile(number,Charges,category,Price) SELECT number,Charges,category,Price FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=E:\Book1.xls',sheet1$)]]></description><category></category></item><item><title><![CDATA[上传下载文件]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83441018</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83441018</guid><author>cbting</author><pubDate>Thu, 13 Aug 2009 23:14:39 +0800</pubDate><description><![CDATA[ protected void Button1_Click(object sender, EventArgs e)    {        //PostedFile获取要上传文件的信息        if (this.files.PostedFile.FileName.Length == 0)        {            Page.ClientScript.RegisterStartu...]]></description><category></category></item><item><title><![CDATA[发送电子邮件]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83441012</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83441012</guid><author>cbting</author><pubDate>Thu, 13 Aug 2009 22:57:28 +0800</pubDate><description><![CDATA[ protected void Button1_Click(object sender, EventArgs e)    {        string from = txtform.Text;        string to = Txtto.Text;        string subject = Txtsubject.Text;        string body = txtbody.T...]]></description><category></category></item><item><title><![CDATA[ GridView取得id ]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83440999</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83440999</guid><author>cbting</author><pubDate>Thu, 13 Aug 2009 22:17:30 +0800</pubDate><description><![CDATA[ 
 gvlist.DataKeyNames = new string[] { &quot;id&quot;};            gvlist.DataBind();
 
int ids =int.Parse( gvlist.DataKeys[e.RowIndex].Value.ToString());
 ]]></description><category></category></item><item><title><![CDATA[ GridView去掉多余的废嘛]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83440997</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83440997</guid><author>cbting</author><pubDate>Thu, 13 Aug 2009 22:15:29 +0800</pubDate><description><![CDATA[ 
 GridView1中的属性EnableViewState=&quot;true&quot;
  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)        {            if (e.Row.RowType==DataControlRowType.DataRow )            {...]]></description><category></category></item><item><title><![CDATA[网页上应用qq登录程序]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83409253</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83409253</guid><author>cbting</author><pubDate>Mon, 22 Jun 2009 21:54:24 +0800</pubDate><description><![CDATA[          &amp;lt;div id=&quot;&quot;&amp;gt;          咨询QQ：&amp;lt;span&amp;gt;&amp;lt;a target=&quot;_blank&quot; href=&quot;http://wpa.qq.com/msgrd?V=1&amp;amp;amp;Uin=6192278&quot;&amp;gt;               &amp;lt;img alt=&quot;点击这里给我发消息&quot; src=&quot;h]]></description><category></category></item><item><title><![CDATA[MD5 的摘要说明]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83404275</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83404275</guid><author>cbting</author><pubDate>Sun, 07 Jun 2009 15:57:03 +0800</pubDate><description><![CDATA[/// &amp;lt;summary&amp;gt;///MD5 的摘要说明/// &amp;lt;/summary&amp;gt;public static class MD5{    public  static string GetMD5(string Input, bool Half)    {        string output = System.Web.Security.FormsAuthentication...]]></description><category></category></item><item><title><![CDATA[迁移数据库中的表的数据]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83402319</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83402319</guid><author>cbting</author><pubDate>Tue, 02 Jun 2009 10:26:28 +0800</pubDate><description><![CDATA[go use Eglobalpurchase go select * into ego.dbo.PurchaserList from PurchaserList go
说明一下：
go use 原数据库名go select * into 目的数据库名.dbo.目的表名 from 原表名 go]]></description><category></category></item><item><title><![CDATA[XML增删改查]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83402133</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83402133</guid><author>cbting</author><pubDate>Mon, 01 Jun 2009 17:26:52 +0800</pubDate><description><![CDATA[//增加节点;
 
 protected void Button1_Click(object sender, EventArgs e)    {        XmlDocument xdoc = new XmlDocument();        string mappath = Server.MapPath(&quot;xml/bolgbooks.xml&quot;);        xdoc.Load(ma...]]></description><category></category></item><item><title><![CDATA[验证电子邮件]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83401271</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83401271</guid><author>cbting</author><pubDate>Fri, 29 May 2009 21:19:53 +0800</pubDate><description><![CDATA[验证电子邮件输入是否正确
 
 
  用户名+@+主机名
 
 
用户名的判断标准;
 
1 用户名允许出现数字.字母,点号,横线,下划线.
2 点号,横线,下划线.不可联系出现(点号,横线,下划线两端必须出现数字,字符串)
3用户名必须以数字,或字母开头,以数字,字母结束.
普通字符+(特殊字符+普通字符)*
[0-9a-zA-Z] +(+表示出现一次以上)([-_.][...]]></description><category></category></item><item><title><![CDATA[验证手机号码]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83401226</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83401226</guid><author>cbting</author><pubDate>Fri, 29 May 2009 16:49:53 +0800</pubDate><description><![CDATA[判断用户输入的手机号码是否正确!
 
要求:
 
1  手机号必须全部是数字字符串;
 
2  以0开头的有12位,否则有11位
 
3  必须覆盖移动和联通的所有号段,对15x 号段的x处理(0,3,6,8,9)  13x 的x不做限制
 
4  最后8不做限定;
 
^0?1(3\\d|5[03689])\\d{8}$&quot;
 
?问号是量词 表示0可能出现一次,也可能...]]></description><category></category></item><item><title><![CDATA[正则表达式验证邮政编码]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83401215</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83401215</guid><author>cbting</author><pubDate>Fri, 29 May 2009 16:18:52 +0800</pubDate><description><![CDATA[正则表达式验证邮政编码:  
 &quot;^\\d{6}$&quot;
 
1. 要求字符串的长度必须的6位数;   {6}
 
2. 每个字符串必须是数字; (0-9) \\d
 
 ]]></description><category></category></item><item><title><![CDATA[正则表达式总结!!!]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83400916</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83400916</guid><author>cbting</author><pubDate>Wed, 27 May 2009 21:03:07 +0800</pubDate><description><![CDATA[1排出行字符组;
作用:规定某个位置不允许出现的字符;
比如: [^...]方括号中不能出现的字符;
注意;[^]不能排除空字符;
2字符串简记法;作用是:方便他们的的使用;\d =[0-9]\D=[^0-9]\w=[0-9a-zA-Z_]\W=[^0-9a-zA-Z_]\s=匹配空白符(回车,换行,制表,空格)\S=非匹配空白符(回车,换行,制表,空格)
3特殊的简记fa
. 好可以...]]></description><category></category></item><item><title><![CDATA[正则表达式资料]]></title><link>https://blog.youkuaiyun.com/cbting/article/details/83400796</link><guid>https://blog.youkuaiyun.com/cbting/article/details/83400796</guid><author>cbting</author><pubDate>Wed, 27 May 2009 14:39:51 +0800</pubDate><description><![CDATA[1排出行字符组;
作用:规定某个位置不允许出现的字符;
比如: [^...]方括号中不能出现的字符;
注意;[^]不能排除空字符;
2字符串简记法;作用是:方便他们的的使用;\d =[0-9]\D=[^0-9]\w=[0-9a-zA-Z_]\W=[^0-9a-zA-Z_]\s=匹配空白符(回车,换行,制表,空格)\S=非匹配空白符(回车,换行,制表,空格)
3特殊的简记fa
. 好可以...]]></description><category></category></item></channel></rss>