Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Do you know the cursor types?

0 Answers  

Does the order of columns in update statements matter?

0 Answers  

What do you understand by intent locks?

0 Answers  

Explain activity monitors

0 Answers  

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

What is a coalesce function?

0 Answers  

What are the recovery models in sql server 2000?

0 Answers  

Explain about Joins?

0 Answers   Infosys,

What is the sql server 2000 version number?

0 Answers  

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

Do you know what are the steps to process a single select statement?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories