--定义两个变量
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
记录一些最基础的语法,以免淡忘