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
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What do you understand by the denormalisation?
Explain the architecture of ms sql reporting service?
How to implement service broker?
What are the types of processing and explain each? : sql server analysis services, ssas
What are functions in the sql server?
Is ssrs support other database except ms sql server?
Do you know what is blocking?
what is normalization? : Sql server database administration
Do I need a report server to run reports in my application?
How to create a stored procedure with a statement block in ms sql server?
What is #temp and @table variable in SQL server?
Is INSTEAD OF trigger directly applicable to Table ?
What area unit the various kinds of info compression introduced in sql server 2008?
What is the full form of dql?