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
- 1 Answers
- 4350 Views
- I also Faced
- E-Mail Answers
Answer Posted / gopi muluka
Use Datetime datatype in database
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Explain sql delete command?
what is datawarehouse?
What is the size of transaction log file?
Define magic tables in sql server?
When should you use an instead of trigger?
What happens if you delete a table that is used by a view?
Why I have to use stored procedures?
Write a SQL command to insert and update only a particular field?
How to concatenate two binary strings together?
What are the differences between lost updates and uncommitted dependencies?
Mention the differences between having and where clause.
Describe in brief authentication modes in sql server.
What is a join in sql?
Can sub report data source be different from that of the parent report?
