AS begin declare @tmp nvarchar(50) declare @stuid int declare @i int declare @claID int set @tmp=@text; insert into students([name],age)values(@name,@age) set @stuid=@@identity --得到新增学生ID while(len(@tmp)>0)-----判断剩余字符串长度是否大于0。 begin set @i=charindex('|',@tmp) ---- @i=2 set @claID=substring(@tmp,1,@i-1) -----@claid=1 insert into SelectClasses(studentID,classID)values(@stuid,@claID); set @tmp=substring(@tmp,@i+1,len(@tmp)-@i) ---@temp='4|15|' end end