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
- 4871 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 dbcc updateusage?
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.
Characterize join and name diverse sorts of joins?
How do you clear a log file?
What is blocking and how would you troubleshoot it?
What is indexing a document?
Explain the steps needed to create a scheduled job?
Explain stored procedure?
What is triggers in ms sql server?
Explain about nested stored procedure?
What's the maximum size of a row?
-
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)
