DECLARE @UserId INT
SET @count = 1
WHILE (@count <= 5000)
BEGIN
INSERT INTO tblUser1(EmailID, UserTypeID,FirstName,LastName,PhoneNumber,UniversityID,RegisterDate,ActivationDate,Status,Password,IsAV)
VALUES ('priyanka'+ CONVERT(nvarchar, @count) + '@gmail.com',5,'priya','darshini','5468927689',10,'2012-04-12 02:09:59.040',null,1,'Test123',1)
SET @count = (@count + 1)
SELECT @UserId = @@IDENTITY
INSERT INTO tblAddress1(UserID,AddressLine1,AddressLine2,City,StateID,ZipCode) Values(@UserId,'test',NULL,'Hyd',34,50040)
END