Interested to Buy Any Domain ? << Click Here >> for more details...
how do we insert 100 records at a time in a table without
using for loop in database
- 1 Answers
- 4787 Views
- I also Faced
- E-Mail Answers
Answer Posted / prashant
FOR SQL Server only -
That depends on where your data (100 rec) is
If it's in a txt file, you may try SQLBULKCOPY:
http://msdn.microsoft.com/en-us/library/7ek5da1a.aspx
else, you may try Data Flow task in SQL Server Integration
Service (SSIS) to upload the data from other source.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What stored by the tempdb ? : sql server database administration
What is measure group, measure? : sql server analysis services, ssas
Explain active/passive and active/active cluster configurations?
What are secondary xml indexes?
What is forward - only cursors / read only cursor?
What are sql server procedures?
What are the instances when triggers are appropriate?
Why we use the openxml clause?
How to get the definition of a user defined function back?
what does the automatic recovery do? : Sql server administration
How will you go about resolving deadlocks?
What is policy based management (pbm)? : sql server database administration
Difference between 2NF &3NF ?
Can I delete event logs?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
