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 copy the tables, schema and views from one sql server to another?
What is the order by used for?
How to create new table with "create table" statements?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are “lost updates”?
What is the purpose of the tempdb database?
What is sub query and its properties?
List few advantages of stored procedure.
How you can add messages to the nt event log from within a stored procedure?
What is view in sql?
What types of replication are supported in sql server?
What are drilldown reports?
Can a table be created inside a trigger?
How many types of triggers in sql server?
What is tabulation?