How do you load large data to the SQL server database?
Answers were Sorted based on User's Feedback
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 |
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 |
How to set database to be single_user in ms sql server?
How to return the second 5 rows in ms sql server?
Explain different types of locks in sql server.
List out the differences between the clustered index and non-clustered index in sql server?
What are partitioned views and distributed partitioned views?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How do I partition a table in sql server?
What is an index. What are the types?
What is difference between join and natural join?
What is the command to change the recovery model?
What is local temp table?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)