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

Write a sql query to delete duplicate records from a table called table1

0 Answers  

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

How do you create type- insensitive operator?

0 Answers   EXL,

How to add an address record into adventureworkslt?

0 Answers  




PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

Tell me extended events in sql server 2008?

0 Answers  

What is optimistic concurrency?

0 Answers  

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

How to create dbo table in sql server?

0 Answers  

Detail about the hardware which is supported by SQL server?

0 Answers  

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories