Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4468 Views
- I also Faced
- E-Mail Answers
Answer Posted / gopi muluka
Use Datetime datatype in database
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are system databases into sql server (2005/2008)?
How important do you consider cursors or while loops for a transactional database?
Explain what is lock escalation and what is its purpose?
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?
What are ddl triggers and types of ddl trigger?
Explain what role entity and relationship play in an ER diagram.
What is a trigger in sql server?
How column data types are determined in a view?
What are the steps to follow to configure SQL*Net?
Tell me about the approaches which you used to counter the DI problems.
How to write character string constants or literals in ms sql server?
What is the difference in accessing db between sql server vs sql azure?
Explain system views?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is difference between group by and having?
