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

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

What is 2nf normalization form?

0 Answers  

explain the type of contraints

3 Answers  

What is optimistic concurrency?

0 Answers  

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

Does partitioning improve performance sql server?

0 Answers  

How do I edit a stored procedure in sql server?

0 Answers  

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

HOW TO RENAME A COLUMN NAME

3 Answers  

What are locks in sql?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories