SQLTeam.com | Weblogs | Forums

Inserting the same record 10000 times


#1

is there a quick way in sql server to insert the same line 10000 times? eg something that loops the insert statement 10000 times

e


#2

insert into tablename
select * from tablename1
go 10000