What is BCP? When do we use it?
Answers were Sorted based on User's Feedback
Answer / gaurav
Check on this URL :
http://intquesans.blogspot.com/2011/06/what-is-bcp-when-does-it-used.html
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / guest
BulkCopy is a tool used to copy huge amount of data from
tables and views. But it won?t copy the structures of the same.
| Is This Answer Correct ? | 8 Yes | 15 No |
What is trigger ?
What do you mean by authentication modes in sql server?
How to use linked server?
How to recreate an existing index in ms sql server?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is difference between equi join and natural join?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
how to implement locking in sql server
What is optimistic concurrency?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,
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)