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
- 4880 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 the restrictions that views have to follow?
How to retrieve error messages using mssql_get_last_message()?
Which language is supported by sql server?
What is partition index in sql server?
Explain what are various ways to enhance the ssrs report?
What are click through reports?
What are ddl (data definition language) statements for tables in ms sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
how to overcome kernel isssues
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain the steps needed to create a scheduled job?
How do I open a .db file?
How to list all triggers in the database with sys.triggers in ms sql server?
What is the function of inner join?
What is transaction server distributed transaction?
