09 2013 档案

用实例展示left Join,right join,inner join,join,cross join,union 的区别
摘要：1.向TI,T2插入数据：T17条IDField2Field3Field411354213543135442354533546435475354T27条IDField22Field2311332133313341335233633379332.测试left joinselectROW_NUMBER()over(orderbyt1.id,t2.id)asrow_num,*fromdbo.T1leftjoindbo.T2ont1.Field2=t2.Field22row_numIDField2Field3Field4IDField22Field231113541133211354213331135 阅读全文
posted @ 2013-09-25 23:32 翱翔之鹰 阅读(988) 评论(0) 推荐(0) 编辑