用无参存储过程循环插入测试数据

USE [数据库名称]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter PROCEDURE dbo.pro_photosImport
AS
declare @i int
set @i = 1
declare @uid int
set @uid= 1
declare @username varchar(64)
set @username =''
declare @cat int
set @cat = 1
while (@i < 600000)
begin
Set @i =@i +1
select @uid = userid,@username=username from  dbo.spb_Users select @cat = categoryid 
   from dbo.spb_PhotoUserCategories 
INSERT INTO [dbo].[spb_Photos]([OwnerUserID],[UserCategoryID],[SiteCategoryID],[Author],[PostDate],
   [LastRepliedDate],[PrivacyStatus],[IsLocked],[Password],[AuditingStatus],[IsEssential],[SpecialOrder],
   [StickyDate],[HitTimes],[CommentCount],[RssViewTimes],[RatingSum],[TotalRatings],[Subject],[Body],
   [UserHostAddress],[FileName],[ContentType],[ContentSize],[Height],[Width],[PropertyNames],[PropertyValues]) 
VALUES(@uid,@cat,0,@username,getdate(),getdate(),30,0,'',40,0,0,'1754-01-01 00:00:00.000',
   1,0,0,0,0,'可爱的图片','我很细可爱的图片哦！','192.168.1.65','2788267502545.jpg','image/jpeg',
   32897,493,330,null,null)  
end
go