aidmondo Starting Member
Ghana 23 Posts
vijays3 Constraint Violating Yak Guru
India 311 Posts
declare @a varchar(20) set @a = 'S00' declare @i int set @i = 1 while (@i <= 100) begin insert into #Mytable (id) values(@a+ cast(@i as varchar(50))) set @i= @i+1 end select * from #Mytable
sunitabeck Flowing Fount of Yak Knowledge
5152 Posts
visakh16 Very Important crosS Applying yaK Herder
India 47023 Posts
Triggers
Posted - 05/12/2012 : 06:17:12
