http://blog.csdn.net/dobear_0922/Nerver try, nerver knowzh-CNMon, 17 Nov 2008 18:42:00 GMT60dobearhttp://blog.csdn.net/dobear_0922/archive/2008/11/12/3280090.aspxWed, 12 Nov 2008 11:18:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/11/12/3280090.aspxhttp://blog.csdn.net/dobear_0922/comments/3280090.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/11/12/3280090.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/3280090.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3280090createtable[tb](ID intidentity(1,1), a int, b int, c int, d int)<br /><br />insert[tb]select1,2,3,4    -- max: 4<br />unionallselect5,2,8,3    -- max: 8<br />unionallselect9,7,6,5    -- max: 9<br />unionallselect0,9,2,2    -- max: 9<br /><br />-- Method 1, by dobear<br />select ID,  Max_abcd=max([value]) <br />from tb <br />unpivot([value]for[abcd]in ([a], [b], [c], [d])) as U<br />groupby ID<br /><br />/*<br />ID          Max_abcd<br />----------- -----------<br />1           4<br />2          <img src ="http://blog.csdn.net/dobear_0922/aggbug/3280090.aspx" width = "1" height = "1" />dobearhttp://blog.csdn.net/dobear_0922/archive/2008/11/04/3216627.aspxTue, 04 Nov 2008 10:35:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/11/04/3216627.aspxhttp://blog.csdn.net/dobear_0922/comments/3216627.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/11/04/3216627.aspx#Feedback13http://blog.csdn.net/dobear_0922/comments/commentRss/3216627.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3216627呵呵，昨天看了海老师的博客，今天也自己写了一个<img src ="http://blog.csdn.net/dobear_0922/aggbug/3216627.aspx" width = "1" height = "1" />dobearhttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539338.aspxThu, 12 Jun 2008 13:22:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539338.aspxhttp://blog.csdn.net/dobear_0922/comments/2539338.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539338.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/2539338.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2539338人民币小写金额转换成大写<img src ="http://blog.csdn.net/dobear_0922/aggbug/2539338.aspx" width = "1" height = "1" />dobearhttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539339.aspxThu, 12 Jun 2008 13:22:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539339.aspxhttp://blog.csdn.net/dobear_0922/comments/2539339.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539339.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/2539339.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2539339人民币小写金额转换成大写<img src ="http://blog.csdn.net/dobear_0922/aggbug/2539339.aspx" width = "1" height = "1" />dobearhttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539335.aspxThu, 12 Jun 2008 13:21:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539335.aspxhttp://blog.csdn.net/dobear_0922/comments/2539335.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/06/12/2539335.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/2539335.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2539335人民币小写金额转换成大写<img src ="http://blog.csdn.net/dobear_0922/aggbug/2539335.aspx" width = "1" height = "1" />dobearhttp://blog.csdn.net/dobear_0922/archive/2008/06/02/2503642.aspxMon, 02 Jun 2008 15:33:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/06/02/2503642.aspxhttp://blog.csdn.net/dobear_0922/comments/2503642.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/06/02/2503642.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/2503642.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2503642写一段SQL代码,它的输出就是这段代码。能实现否？<img src ="http://blog.csdn.net/dobear_0922/aggbug/2503642.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2008/04/22/2313839.aspxTue, 22 Apr 2008 10:16:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/04/22/2313839.aspxhttp://blog.csdn.net/dobear_0922/comments/2313839.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/04/22/2313839.aspx#Feedback9http://blog.csdn.net/dobear_0922/comments/commentRss/2313839.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2313839在SQL中分类合并数据行<img src ="http://blog.csdn.net/dobear_0922/aggbug/2313839.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2008/04/18/2304165.aspxFri, 18 Apr 2008 14:14:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/04/18/2304165.aspxhttp://blog.csdn.net/dobear_0922/comments/2304165.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/04/18/2304165.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/2304165.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2304165SQL２００５下使用CTE的一个示例<img src ="http://blog.csdn.net/dobear_0922/aggbug/2304165.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2008/04/15/2294877.aspxTue, 15 Apr 2008 19:18:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/04/15/2294877.aspxhttp://blog.csdn.net/dobear_0922/comments/2294877.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/04/15/2294877.aspx#Feedback1http://blog.csdn.net/dobear_0922/comments/commentRss/2294877.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=229487780后男士征婚标准（巨经典）<img src ="http://blog.csdn.net/dobear_0922/aggbug/2294877.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2008/04/01/2235256.aspxTue, 01 Apr 2008 11:19:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/04/01/2235256.aspxhttp://blog.csdn.net/dobear_0922/comments/2235256.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/04/01/2235256.aspx#Feedback1http://blog.csdn.net/dobear_0922/comments/commentRss/2235256.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2235256禁用聚集索引来阻止对表的访问(暂停使用某个表，但不删除)<img src ="http://blog.csdn.net/dobear_0922/aggbug/2235256.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2008/03/31/2232531.aspxMon, 31 Mar 2008 11:48:00 GMThttp://blog.csdn.net/dobear_0922/archive/2008/03/31/2232531.aspxhttp://blog.csdn.net/dobear_0922/comments/2232531.aspxhttp://blog.csdn.net/dobear_0922/archive/2008/03/31/2232531.aspx#Feedback1http://blog.csdn.net/dobear_0922/comments/commentRss/2232531.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2232531数据并不总是按照聚集索引来排序的。微软BI开拓者 http://www.windbi.com<img src ="http://blog.csdn.net/dobear_0922/aggbug/2232531.aspx" width = "1" height = "1" />dobearhttp://blog.csdn.net/dobear_0922/archive/2007/12/18/1947219.aspxTue, 18 Dec 2007 17:20:00 GMThttp://blog.csdn.net/dobear_0922/archive/2007/12/18/1947219.aspxhttp://blog.csdn.net/dobear_0922/comments/1947219.aspxhttp://blog.csdn.net/dobear_0922/archive/2007/12/18/1947219.aspx#Feedback5http://blog.csdn.net/dobear_0922/comments/commentRss/1947219.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1947219自己写的一个函数：根据月分打印月历【SQL版】<img src ="http://blog.csdn.net/dobear_0922/aggbug/1947219.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2007/12/15/1937825.aspxSat, 15 Dec 2007 10:20:00 GMThttp://blog.csdn.net/dobear_0922/archive/2007/12/15/1937825.aspxhttp://blog.csdn.net/dobear_0922/comments/1937825.aspxhttp://blog.csdn.net/dobear_0922/archive/2007/12/15/1937825.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/1937825.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1937825part of the game<img src ="http://blog.csdn.net/dobear_0922/aggbug/1937825.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2007/11/13/1881776.aspxTue, 13 Nov 2007 10:56:00 GMThttp://blog.csdn.net/dobear_0922/archive/2007/11/13/1881776.aspxhttp://blog.csdn.net/dobear_0922/comments/1881776.aspxhttp://blog.csdn.net/dobear_0922/archive/2007/11/13/1881776.aspx#Feedback2http://blog.csdn.net/dobear_0922/comments/commentRss/1881776.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1881776小事招魂，大事挖坟！<img src ="http://blog.csdn.net/dobear_0922/aggbug/1881776.aspx" width = "1" height = "1" />dobear_0922http://blog.csdn.net/dobear_0922/archive/2007/10/15/1825021.aspxMon, 15 Oct 2007 09:04:00 GMThttp://blog.csdn.net/dobear_0922/archive/2007/10/15/1825021.aspxhttp://blog.csdn.net/dobear_0922/comments/1825021.aspxhttp://blog.csdn.net/dobear_0922/archive/2007/10/15/1825021.aspx#Feedback0http://blog.csdn.net/dobear_0922/comments/commentRss/1825021.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1825021人生重要的不是所站的位置，而是所朝的方向<img src ="http://blog.csdn.net/dobear_0922/aggbug/1825021.aspx" width = "1" height = "1" />