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
- 4883 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the cartesian product of table?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is delete query?
How can you hide the sql server instances?
Explain how to integrate the ssrs reports in application?
Can you explain what is indexed view? How to create it?
What are the differences between char and nchar in ms sql server?
What is the query and subquery?
Why we need sql server?
How to find the list of fixed hard drive and free space on server?
What is tabulation?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
