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  

---

Can we do dml on views?

0 Answers  

---

Define left outer join in sql server joins?

0 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

What happens if we shrink log file in sql server?

0 Answers  

---

How to delete duplicate rows from table except one?

0 Answers  

---

What are synonyms?

0 Answers  

---

What is the advantage of sql server?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---