這些問題我見到才能說出來，反之就不行....

如果你有時間的話，仔細看看這兩本書叭，作者是特大牛，很多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!!