摘要:
USE [Test]GOdeclare @i intdeclare @idToTest intdeclare @nameToTest varchar(50)Set @i=10While @i<=12beginset @idToTest=@iset @nameToTest ='Test'+convert(varchar,@i)insert into [Test].[dbo].[Name] values (@idToTest,@nameToTest )set @i=@i+1end 阅读全文