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
4786 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

How to create function with parameter in sql server?

0 Answers

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

0 Answers

What is sleeping status in sql server?

0 Answers

What stored procedure would you use to view lock information?

0 Answers

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers

What is an indice?

0 Answers

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers

What is molap and its advantage? : sql server analysis services, ssas

0 Answers

What is BCP? When does it used in sql server 2012?

0 Answers TryTechnicals Pvt Ltd,

What is create command?

0 Answers

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers

For more SQL Server Interview Questions Click Here