; With cte as (select top @ I id1 from the test order by newid ())
Insert into testall (id1) select * from cte

Near the tip @ I mistake

CodePudding user response:

The problem has been solved, thank @ I add a bracket