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
What is collation sensitivity? Explain different types.
Tell me what is the difference between locking and multi-versioning?
How do I install sql server?
How to create indexed view?
Explain where clause?
How to change a login name in ms sql server?
How connect excel to sql server?
What are sql azure firewall rules?
How do I perform an unattended install of sql server 2000?
what are cursors? : Sql server database administration
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is a virtual table in sql?
What is a fill factor?
How many types of built in functions are there in sql server 2012?