Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 Schema in Database?

1 Answers   Cap Gemini,

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

What are the purpose of Normalisation?

0 Answers   HCL,

Explain the properties of the relational tables?

0 Answers  

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

How do I delete a sql server database?

0 Answers  

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

List out some of the requirements to set up a sql server failover cluster?

0 Answers  

What is the query and subquery?

0 Answers  

What is @@Identity in sql?

1 Answers   Cap Gemini,

What are the components of sql server service broker?

0 Answers  

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories