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
- 4524 Views
- I also Faced
- E-Mail Answers
what is the difference between group and having give an example with query and sample output
Do you know the capabilities of cursors?
What is a join in sql? What are the types of joins?
What are the advantages of using third-party tools?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
What do you mean by COLLATION?
What is live lock and deadlock? what is Lock escalation?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What are the database objects? : SQL Server Architecture
Explain system rowset functions?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is field with example?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
