存储过程-- 增加测试数据

USE [Test]

GO

declare @i int

declare @idToTest int

declare @nameToTest varchar(50)

Set @i=10

While @i<=12

begin

set @idToTest=@i

set @nameToTest ='Test'+convert(varchar,@i)

insert into [Test].[dbo].[Name] values (@idToTest,@nameToTest )

set @i=@i+1

end