22,209
社区成员
发帖
与我相关
我的任务
分享
select huiyuan_bianhao from tbl_huiyuan
insert into ecs_users(user_name,password) values('123456','4a7d1ed414474e4033ac29ccb8653d9b');
DECLARE @NUMBER VARCHAR(50), @ID VARCHAR(50)
DECLARE Cursor1 CURSOR FOR SELECT NUMBER ,ID FROM TABLE1
OPEN Cursor1
FETCH NEXT FROM Cursor1 INTO @NUMBER ,@ID
WHILE @@FETCH_STATUS=0
INSERT INTO TABLE2 VALUES(@NUMBER ,@ID)
FETCH NEXT FROM Cursor1 INTO @NUMBER ,@ID
BEGIN
CLOSE Cursor1
DEALLOCATE Cursor1
END