摘要:
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
阅读(192)
评论(0)
推荐(0)
浙公网安备 33010602011771号