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
- 4866 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 are .mdf files?
What is b tree index?
How can we rewrite sub-queries into simple select statements or with joins?
How will you make an attribute not process? : sql server analysis services, ssas
What is the recovery model?
Will count(column) include columns with null values in its count?
What is database black box testing?
What is the difference between varchar and varchar(max) datatypes?
What is the meaning of resultset type_scroll_insensitive?
Which tcp/ip port does sql server run on? How can it be changed?
Can we call future method from queueable?
How to get the query of a table in sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Give an example of why you would want to denormalize a database
Explain raiserror in sql server?
