<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[aspx_RICK的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/aspx_RICK</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; aspx_RICK]]></copyright><item><title><![CDATA[查看sql表大小]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/4180734</link><guid>https://blog.csdn.net/aspx_RICK/article/details/4180734</guid><author>aspx_RICK</author><pubDate>Thu, 14 May 2009 01:33: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 varchar(50) ,rowsi]]></description><category></category></item><item><title><![CDATA[mssql 分页程序]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/4092913</link><guid>https://blog.csdn.net/aspx_RICK/article/details/4092913</guid><author>aspx_RICK</author><pubDate>Sun, 19 Apr 2009 22:18:00 +0800</pubDate><description><![CDATA[1.写的一个mssql 数据分页程序 declare @sql nvarchar(4000)declare @i int --当前页 set @i=2select @sql=Nselect top 10 * from set_ProductData    where 1=1 and (ProductKey in      (select top + Convert(nvarchar(1]]></description><category></category></item><item><title><![CDATA[22]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/3776384</link><guid>https://blog.csdn.net/aspx_RICK/article/details/3776384</guid><author>aspx_RICK</author><pubDate>Wed, 14 Jan 2009 14:45:00 +0800</pubDate><description><![CDATA[select b.* from ( select rownum bnum, a.* from      (select rownum anum, t.*from abss_greenet_userlog t      where create_date > to_date(2008-11-25 00:00:00,yyyy-mm-dd hh24:mi:ss) order by create_]]></description><category></category></item><item><title><![CDATA[11]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/3776348</link><guid>https://blog.csdn.net/aspx_RICK/article/details/3776348</guid><author>aspx_RICK</author><pubDate>Wed, 14 Jan 2009 14:42:00 +0800</pubDate><description><![CDATA[1.extract(month from to_date(p_starttime, yyyymmdd));2.to_char(3.trunc(v_count / pagesize)4.create or replace trigger beforeUpdateService  before update on greenet_user_service_info    for each rowd]]></description><category></category></item><item><title><![CDATA[取IP地址]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/2969604</link><guid>https://blog.csdn.net/aspx_RICK/article/details/2969604</guid><author>aspx_RICK</author><pubDate>Tue, 23 Sep 2008 18:11:00 +0800</pubDate><description><![CDATA[Request.UserHostAddress  取IP地址]]></description><category></category></item><item><title><![CDATA[dblink]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/2916289</link><guid>https://blog.csdn.net/aspx_RICK/article/details/2916289</guid><author>aspx_RICK</author><pubDate>Fri, 12 Sep 2008 10:20:00 +0800</pubDate><description><![CDATA[create public database link FS.US.ORACLE.COM  connect to GREENET identified by greenet  using ]]></description><category></category></item><item><title><![CDATA[123]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/2863366</link><guid>https://blog.csdn.net/aspx_RICK/article/details/2863366</guid><author>aspx_RICK</author><pubDate>Mon, 01 Sep 2008 21:19:00 +0800</pubDate><description><![CDATA[alter table GREENET_USER_LOGadd(LASTOPERATE varchar2(1024)) ]]></description><category></category></item><item><title><![CDATA[获取URL路径]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/2839086</link><guid>https://blog.csdn.net/aspx_RICK/article/details/2839086</guid><author>aspx_RICK</author><pubDate>Wed, 27 Aug 2008 17:01:00 +0800</pubDate><description><![CDATA[string webUrl = string.Format("{0}://{1}{2}{3}",            Request.Url.Scheme,            Request.Url.Authority,            Request.Url.Segments[0],            Request.Url.Segments[1]);        if (!w]]></description><category></category></item><item><title><![CDATA[javascript 分页]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/1249618</link><guid>https://blog.csdn.net/aspx_RICK/article/details/1249618</guid><author>aspx_RICK</author><pubDate>Tue, 19 Sep 2006 22:10:00 +0800</pubDate><description><![CDATA[script type ="text/javascript">   var objs= document.all;    if(objs!=null)    {         var msg=objs.length+"/r";      var pageIdex ;      var size ;      size=20;             msg=msg+parseInt(objs.l]]></description><category></category></item><item><title><![CDATA[   SQL语法 操作]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/1249518</link><guid>https://blog.csdn.net/aspx_RICK/article/details/1249518</guid><author>aspx_RICK</author><pubDate>Tue, 19 Sep 2006 21:50:00 +0800</pubDate><description><![CDATA[   SQL语法 1.基本语法 (1)插入  INSERT mytable (first_column,second_column,third_column)  VALUES (‘some data’,’some more data’,’yet more data’)  (2)修改  UPDATE mytable  SET  first_column=’Updated!’             ]]></description><category></category></item><item><title><![CDATA[JScript 滤镜 WAVE]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/1249509</link><guid>https://blog.csdn.net/aspx_RICK/article/details/1249509</guid><author>aspx_RICK</author><pubDate>Tue, 19 Sep 2006 21:48:00 +0800</pubDate><description><![CDATA[  // JScript 文件//对静态滤镜的使用 加入    即可 /* 1.滤镜*/             img.aFilter {FILTER:PROGID:DXIMAGETRANSFORM.MICROSOFT.WAVE(        Add=false, LightStrength=200, Phase=0, Strength=8,  Freq=3);}         ]]></description><category></category></item><item><title><![CDATA[ 网址]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/1210668</link><guid>https://blog.csdn.net/aspx_RICK/article/details/1210668</guid><author>aspx_RICK</author><pubDate>Tue, 12 Sep 2006 02:05:00 +0800</pubDate><description><![CDATA[http://www.microsoft.com/China/community/dgbrowser/zh-cn/default.mspx?fltr=,1,&guid=&sloc=zh-cn&dg=microsoft.public.cn.dotnet.framework.aspnet ]]></description><category></category></item><item><title><![CDATA[双重循环sql操作]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/1151773</link><guid>https://blog.csdn.net/aspx_RICK/article/details/1151773</guid><author>aspx_RICK</author><pubDate>Thu, 31 Aug 2006 22:09:00 +0800</pubDate><description><![CDATA[双重循环sql操作(二个变量@UserID,@RightID,@Max为@UserID的最大值)declare @UserID int,@Max int,@RightID intset @UserID=(select top 1 UserID  from [sys_UserRight] order by userid asc)set @Max=(select top 1 UserID  from ]]></description><category></category></item><item><title><![CDATA[ 开篇]]></title><link>https://blog.csdn.net/aspx_RICK/article/details/838061</link><guid>https://blog.csdn.net/aspx_RICK/article/details/838061</guid><author>aspx_RICK</author><pubDate>Tue, 27 Jun 2006 01:05:00 +0800</pubDate><description><![CDATA[      大家好，我是一ASP.net的开发者与爱好者，今天突然想来写点东西，是偶尔看到别人写Blog+上自已平常在工作和学习中有一些感受外加一些困惑，附带着对asp.net的强列爱好，所以来写写。    作为一个asp.net的爱好者，我认为技术是无止境的。需要与大家一起学习和交流。    初次见面，留下联系方式：    MSN：zengfeitom@yahoo.com.cn]]></description><category></category></item></channel></rss>