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...

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

Answer Posted / gopi muluka

Use Datetime datatype in database

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to copy the tables, schema and views from one sql server to another?

989


What is the order by used for?

965


How to create new table with "create table" statements?

994


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1961


What are “lost updates”?

948


What is the purpose of the tempdb database?

957


What is sub query and its properties?

916


List few advantages of stored procedure.

924


How you can add messages to the nt event log from within a stored procedure?

989


What is view in sql?

852


What types of replication are supported in sql server?

997


What are drilldown reports?

140


Can a table be created inside a trigger?

920


How many types of triggers in sql server?

969


What is tabulation?

896