How can we insert 100 records @ a time without using for loop into the databse

Answer Posted / vinodh kumar

if you are inserting values from another table. then you can use this.

insert into table name
select <columns> from <table1>

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it true that all c# types derive from a common base class?

728


Define the term immutable ?

804


What do you mean by delegates and explain different types of delegates?

719


Are constructors inherited c#?

665


These questions were asked me in a technical interview: •If we deploy an application on multiple server (like database server, web server) then, each request should be redirected to proper server, then how you will handle it in your code? •How security pinholes will be handled in an application? •What things should be considered while writing a web application? •How will you do load/performance testing of web application? Which framework you will use for it? •How will you implement a cache for results which require a DB access? Please let me know how to write an web application considering all these points. I am not so much aware of architechural design of web application. Your guidelines will be helpful.

2734


What is main thread in c#?

684


What is difference between list and ilist in c#?

627


Can we change static value in c#?

727


What are data types in C#?

736


Can we create instance of private class in c#?

676


what is a destructor?

786


Are c and c# the same thing?

658


Where static variables are stored?

656


Why c# is called type safe language?

632


What is difference between event and delegate in c#?

668