https://blog.youkuaiyun.com/FreeSweetzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/FreeSweet/article/details/7583221https://blog.youkuaiyun.com/FreeSweet/article/details/7583221FreeSweetSat, 19 May 2012 17:06:08 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/5903403https://blog.youkuaiyun.com/FreeSweet/article/details/5903403FreeSweetFri, 24 Sep 2010 15:43:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/5885625https://blog.youkuaiyun.com/FreeSweet/article/details/5885625FreeSweetWed, 15 Sep 2010 12:07:00 +0800单个字段：case column when .. then .. else .. end
多个字段：case when ..and .. then.. else ..end]]>https://blog.youkuaiyun.com/FreeSweet/article/details/5885602https://blog.youkuaiyun.com/FreeSweet/article/details/5885602FreeSweetWed, 15 Sep 2010 11:54:00 +0800使用系统表，可以查询表，存储过程，视图等
select * from sys.syscomments where text like'%SendWorkHourMessage_1830%']]>https://blog.youkuaiyun.com/FreeSweet/article/details/4702782https://blog.youkuaiyun.com/FreeSweet/article/details/4702782FreeSweetTue, 20 Oct 2009 11:45:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/4594128https://blog.youkuaiyun.com/FreeSweet/article/details/4594128FreeSweetFri, 25 Sep 2009 14:48:00 +08000  BEGIN   SET @No=STUFF(@No,PATINDEX(%[^0-9]%,@No),1,) --删掉一个非数字的字符，循环结束，剩余的为数字部分 END  RETU]]>https://blog.youkuaiyun.com/FreeSweet/article/details/4541580https://blog.youkuaiyun.com/FreeSweet/article/details/4541580FreeSweetFri, 11 Sep 2009 10:10:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/3191510https://blog.youkuaiyun.com/FreeSweet/article/details/3191510FreeSweetFri, 31 Oct 2008 09:51:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/2947361https://blog.youkuaiyun.com/FreeSweet/article/details/2947361FreeSweetThu, 18 Sep 2008 15:19:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/2937282https://blog.youkuaiyun.com/FreeSweet/article/details/2937282FreeSweetTue, 16 Sep 2008 17:21:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/2751935https://blog.youkuaiyun.com/FreeSweet/article/details/2751935FreeSweetFri, 01 Aug 2008 10:30:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/2751917https://blog.youkuaiyun.com/FreeSweet/article/details/2751917FreeSweetFri, 01 Aug 2008 10:28:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/2695404https://blog.youkuaiyun.com/FreeSweet/article/details/2695404FreeSweetWed, 23 Jul 2008 11:47:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/2695355https://blog.youkuaiyun.com/FreeSweet/article/details/2695355FreeSweetWed, 23 Jul 2008 11:42:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/2693638https://blog.youkuaiyun.com/FreeSweet/article/details/2693638FreeSweetWed, 23 Jul 2008 08:27:00 +0800https://blog.youkuaiyun.com/FreeSweet/article/details/1721107https://blog.youkuaiyun.com/FreeSweet/article/details/1721107FreeSweetWed, 01 Aug 2007 15:14:00 +0800改成这样就好了：但页面稍有变化，一些样式会不起作用了。在google中找到了以下解决办法var scrollPos; if (typeof window.pageYOffset != undefined) {    scrollPos = window.pageYO]]>