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
Can we delete data from a view?
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
Is it possible to delete duplicate rows in a table without using a temporary table ?
What happens to a statement batch if there is a compilation error?
What is the use of partition by in sql server?
What are the types of subquery?
Explain raiserror in sql server?
What is user-defined inline table-valued function?
What is the datatype of rowid?
what is the cursor life span?
What is the difference between resultset and resultsetmetadata?
How many types of built in functions are there in sql server 2012?
Oracle (3259)
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)