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
- 3868 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
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to select true false based on column value in sql server?
what is the difference between count(*) and count(1) ?
What is a user-defined function in the sql server and what is its advantage?
When would you use the stored procedures or functions?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Explain index in sql server?
What is difference between rownum and rowid?
What happens if strings are casted into wrong code pages in ms sql server?
How do I determine how many instances of sql server are installed on a computer?
Why are sql functions used?
What are the tool windows in sql server management studio? : sql server management studio
What is the purpose of sql profiler in sql server?
Tell me about builtinadministrator?
How to list all stored procedures in the current database using ms sql server?
