sql server 语句 循环 、游标、临时表

create TABLE #TMP (I_SarInfor varchar(10)) -- 创建一个临时表insert into #TMPSELECT A.I_SailorInfoID FROM CERT_SailorLetter A LEFT JOINCREW_SailorInfo BON A.I_SailorInfoID = B.I_SailorInfoIDLEFT JOINCOM_LetterName C ON A.NVC_LetterNameCode = C.NVC_LetterNameCodeLEFT JOINCOM_Position D ON B.NVC_Positi...
posted @ 2013-03-20 10:28  Elite_Y  阅读(5715)  评论(0)  编辑  收藏  举报