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

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

Explain the architecture of ms sql reporting service?

0 Answers  

What is trigger ?

7 Answers   Cap Gemini, SQL,

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

How do I get to sql server configuration manager?

0 Answers  

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

What does it mean if @@cursor_row returns a negative number?

0 Answers  

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

What is the difference RDBMS and Graph Database?

0 Answers   EXL,

For more SQL Server Interview Questions Click Here
Categories