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
- 4935 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
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Explain mixed authentication mode of sql server?
What do we have to check in database testing?
What does it mean to manipulate data?
How to use subqueries with the in operators in ms sql server?
What are the new scripting capabilities of ssms? : sql server management studio
What is row_number()?
What happens if you insert a duplicate key for the primary key column in ms sql server?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is the purpose of linked server configuration in sql server?
What is @@error in sql?
What is the current limitation of the size of SQL Azure DB?
What are the indexes in sql server?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Define right outer join?
