when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

What is difference between index and primary key?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

Explain the use of containers in ssis and also their types?

0 Answers  

---

How to receive output values from stored procedures?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

What are the methods used to protect against sql injection attack?

0 Answers  

---

How many levels of sp nesting are possible?

0 Answers  

---