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

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

What is a dbms wizard?

0 Answers  

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

What is the full form of dql?

0 Answers  

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

What is split brain scenario in DB mirroring?

1 Answers  

What is the use of group by clause?

0 Answers  

Give an example of why you would want to denormalize a database

0 Answers  

How to create a simple stored procedure in ms sql server?

0 Answers  

What will be the maximum number of indexes per table?

0 Answers  

could u plz explain about joins and views?

2 Answers  

What do you understand by check constraint in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories