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
- 4849 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 is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Which are ddl commands?
What are the differences between lost updates and uncommitted dependencies?
What objects does the fn_my_permissions function reports on? : sql server security
Explain what is lock escalation and what is its purpose?
Name three of the features managed by the surface area configuration tool? : sql server security
What is the largest component inside a field?
What is buffer cash and log cache in sql server?
What is openxml in sql server?
Explain the difference between functions and stored procedures in sql server?
what is a traditional network library for sql servers? : Sql server database administration
What is the difference between set and select?
what are different types of raid configurations? : Sql server database administration
How to use values from other tables in update statements in ms sql server?
what are the different types of SSRS reports?
