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



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

Can we call stored procedure in trigger?

0 Answers  


Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  


From where can you change the default port?

3 Answers  


What is the difference between indexing and hashing?

0 Answers  


What is the difference between index seek vs. Index scan?

0 Answers  






Why would you use sql agent?

0 Answers  


Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  


What is set nocount on?

0 Answers  


What is the purpose of linked server configuration in sql server?

0 Answers  


What happens if null values are involved in boolean operations?

0 Answers  


which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,


How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,


Categories