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
Answer Posted / gopi muluka
Use Datetime datatype in database
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to defragment indexes with alter index ... Reorganize?
List the various tools available for performance tuning?
What is normalization of database? What are its benefits?
Suggest a method of joining two tables.
Explain the properties of subqueries in sql server?
Explain external key management in sql server 2008
How does the report manager work in SSRS?
What is a cube? : sql server analysis services, ssas
Explain the advantages of merge replication?
What is abstracting periodical?
What is the stuff and how does it differ from the replace function?
How to read data in a table with "select" statements?
What are the types of table?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the maximum size of column in sql server?