How do you load large data to the SQL server database?

Answers were Sorted based on User's Feedback



How do you load large data to the SQL server database?..

Answer / uma lakshman

Quickest method to load large data into a table is to
use "BCP"(bulk copy).

Is This Answer Correct ?    11 Yes 0 No

How do you load large data to the SQL server database?..

Answer / rajendra prasad reddy penumall

YESit is possibl by using TEXT data type.
It cn handle data upto 2GB

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

explain different types of joins? : Sql server database administration

1 Answers  


Define a cross join?

1 Answers  


how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,


How to resolve the orphan use problem? : sql server security

1 Answers  


9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  


What is an indexing strategy?

1 Answers  


How to use go command in "sqlcmd"?

1 Answers  


How many index keys possible for a table

6 Answers  


What is the difference between resultset and resultsetmetadata?

1 Answers  


What function does a database engine serve in the sql server?

1 Answers  


How to create and drop temp table in sql server?

1 Answers  


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1 Answers  


Categories