Answer / Deepshikha Chauhan

The following conditions must be met to bulk copy data into a SQL Server database using bcp:
1. The source and destination databases must be compatible in terms of data types.
2. The target table should have the same structure as the source file, including column order and data types.
3. The user running bcp must have the necessary permissions to access the source file and the destination database.
4. The SQL Server instance should support bulk copy operations (bcp). This is usually enabled by default.

What is Replication?

1 Answers  

---

How to add a new dsn with the odbc driver for sql server?

1 Answers  

---

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

---

How to drop an existing table?

1 Answers  

---

How to write a query with a right outer join in ms sql server?

1 Answers  

---

What are unicode character string data types in ms sql server?

1 Answers  

---

What are the requirements on sql server network connections?

1 Answers  

---

Does server sql treat char as a variable-length or fixed-length column?

1 Answers  

---

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

1 Answers  

---

Display a roll having miminum marks in two subjects?

7 Answers   Patni,

---

what is an sql server?

1 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---