Please check this link...all your doubts will be cleared

http://sinshith.wordpress.com/2010/04/12/bulkinsert-process/

Thank you all..I got lots of new ideas....New techniques..And lots of suggestions....I have taken all comments positively..And i have to learn more..I am new to DB development(One year experience)..I need...

Actually i was expecting different methods for counting 1 to 100.Methods using CTE,While loop,Go to,Cursor......I was expecting some different methods than this...Gail posted a different method...Thats why i told 'Correct...

Hello Friends,

I made necessary changes on the program. Now it will work smoothly..I will be careful from next time

Hi friends,

I am really happy to see Lots of ideas....You can visit my blog also

http://sinshith.wordpress.com/

And let me know your comments...I started writing blog recently

Still many methods are there.....Please contribute your ideas

Please contribute ur ideas...I have got only one correct answer....

Great Answer.........with using master.sys.columns......I never tried it b4........Thank u Gail.....

Try this modified Query..........

CREATE TABLE TESTo

(

acct_id int ,

email_alert_stub uniqueidentifier,

email varchar(100),

seq_no int identity(1,1) not null

)

insert into testo

VALUES(2133,'D189110E-6551-4AE8-B8B9-DDCA9D885BE8','mlu@l.mail')

insert into testo

VALUES(2133,'D189110E-6551-4AE8-B8B9-DDCA9D885BE8','bkumar@cv')

insert into testo

VALUES(2133,'D189110E-6551-4AE8-B8B9-DDCA9D885BE8','bhuv@wdc')

insert into testo

VALUES(2133,'D189110E-6551-4AE8-B8B9-DDCA9D885BE8','aaa@qqq')

select * from testo