Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how do we insert 100 records at a time in a table without
using for loop in database

Question Posted / vijeta tomar


how do we insert 100 records at a time in a table without using for loop in database..

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

Post New Answer

More SQL Server Interview Questions

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

0 Answers  

What are the differences between decimal and float in ms sql server?

0 Answers  

List some major differences between triggers and stored procedures?

0 Answers  

What is the difference between mysql and mysqli?

0 Answers   HCL,

Do you know nested transaction?

0 Answers  




What is a database table?

0 Answers  

What is a bit datatype?

0 Answers  

How to insert data into an existing table?

0 Answers  

From where can you change the default port?

3 Answers  

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

Can a function call a stored procedure in sql server?

0 Answers  

How can a user-defined datatype be created?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories