这些问题我见到才能说出来，反之就不行....

如果你有时间的话，仔细看看这两本书叭，作者是特大牛，很多MVP都对他推崇备至.网上应该有free的ebook.

http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/ref=sr_1_10?ie=UTF8&s=books&qid=1265948460&sr=8-10

http://www.amazon.com/Inside-Microsoft-Server-2005-Pro-Developer/dp/0735621977/ref=pd_bxgy_b_img_b

还有两个论坛是我经常去混得

http://stackoverflow.com/questions/tagged/sql+sql-server

http://social.msdn.microsoft.com/forums/en-US/transactsql/threads/

至于那些CTE, row_number,你google一下，一堆堆的例子，

http://www.sqlservercentral.com/articles/Development/commontableexpressionsinsqlserver2005/1758/

http://msdn.microsoft.com/en-us/library/ms186734.aspx

good luck!!