create proc  ppas declare @n intset @n=1while @n<=100begininsert into student values(‘11341101320‘+LTRIM(@n),‘Jack‘+ltrim(@n),‘男‘,22,‘上海‘,‘18272986984‘,‘上海‘)  --ltrim(@n) 转成字符串 拼接学号--insert into student values(‘1134110120‘+@n,‘Jack‘+ltrim(@n),‘男‘,22,‘上海‘,‘18272986984‘,‘上海‘)set @n=@n+1ENDgoEXEC pp;go drop procedure  pp;