摘要:        
select UserID into #Test from dbo.User_Basic where UserID not in (select UserID from dbo.User_Detail)declare my_cursor cursorforselect UserID from #Testopen my_cursordeclare @UserID varchar(50)fetch next from my_cursor into @UserIDwhile(@@fetch_status=0)begininsert into User_Detail(UserID) values(@U    阅读全文
        
            posted @ 2011-07-20 16:29
zwei
阅读(191)
评论(0)
推荐(0)
        
     
                    
                     
                    
                 
                    
                 
                
 
 
         浙公网安备 33010602011771号
浙公网安备 33010602011771号