Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / vssunil86


when u import an excel file into sql if suppose one column has got a date field with system time at..

Answer / gopi muluka

Use Datetime datatype in database

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the data type of time?

0 Answers  

Does a full backup include transaction log?

0 Answers  

Define a cross join?

0 Answers  

How do I partition a table in sql server?

0 Answers  

Explain subquery and state its properties?

0 Answers  




What is data source in connection string?

0 Answers  

Tell me what is difference between view and materialized view?

0 Answers  

Explain in brief about Microsoft SQL server?

0 Answers  

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

Why I have to use stored procedures?

0 Answers   Cognizant,

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

How will you decide the active and passive nodes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories