摘要: 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 阅读全文
posted @ 2011-11-10 14:51 xiaoshiyilang 阅读(116) 评论(0) 推荐(0) 编辑