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

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

Question Posted / vijeta tomar

1 Answers
4232 Views
I also Faced
E-Mail Answers

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

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers

What is sql server management studio? : sql server management studio

0 Answers

How to create a ddl trigger using "create trigger" statements?

0 Answers

What are the steps to process a single select statement?

0 Answers

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers TVS,

What is normalization? What number of normalization shapes are there?