declare @sql nvarchar(1000)
declare @ss_count int,@looptimes int
set @ss_count=(select count(*) from SS_STUDENT2)
set @looptimes=@ss_count*2/3
set @sql='insert into SS_STUDENT2_MODEL(student_id,teacher_id) '
+' select Top '+@looptimes+' student_id,teacher_id from SS_STUDENT2 Order By NewID()'
exex(@sql)
declare @ss_count int,@looptimes int
set @ss_count=(select count(*) from SS_STUDENT2)
set @looptimes=@ss_count*2/3
set @sql='insert into SS_STUDENT2_MODEL(student_id,teacher_id) '
+' select Top '+@looptimes+' student_id,teacher_id from SS_STUDENT2 Order By NewID()'
exex(@sql)
@looptimes int
@S Varchar(8000)
set @ss_count=(select count(*) from SS_STUDENT2)
set @looptimes=@ss_count*2/3Set @S='insert into SS_STUDENT2_MODEL(student_id,teacher_id) select Top '+Rtrim(@looptimes)+' student_id,teacher_id from SS_STUDENT2 Order By NewID()'
EXEC(@S)
@looptimes int,
@S Varchar(8000)
set @ss_count=(select count(*) from SS_STUDENT2)
set @looptimes=@ss_count*2/3Set @S='insert into SS_STUDENT2_MODEL(student_id,teacher_id) select Top '+Rtrim(@looptimes)+' student_id,teacher_id from SS_STUDENT2 Order By NewID()'
EXEC(@S)
谢谢所有回复这个帖子,所有回复 CSDN 有疑问帖子的热心同仁们~~!!!!!!
致敬!!!!!!!!!!!!!!!