循环插入500条数据

--定义两个变量
declare @i int
declare @insertvalue varchar(50)
--设置i的初始值
set @i=0
--循环500
while(@i<500)
begin
 set @i=@i+1
 set @insertvalue=cast(@i as varchar) --i类型转换

 INSERT INTO [Vendition].[dbo].[Customers]
           ([CustomerID]
           ,[CompanyName]
           ,[ContactName]
           ,[ContactTitle]
           ,[Address]
           ,[City]
           ,[Region]
           ,[PostalCode]
           ,[Country]
           ,[Phone]
           ,[Fax])
     VALUES
           (@insertvalue
           ,'asdasd'
           ,'萨斯大声'
           ,'asdasd'
           ,'asdasd'
           ,'asdasd'
           ,'sdfsdf'
           ,'safds'
           ,'qwewr'
           ,'dvds'
           ,'eree')
end

select * from Customers order by CustomerID asc

 

记录一些最基础的语法，以免淡忘