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
explain the type of contraints
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000
17 Answers HCL, IBM,
How to create a simple table to test triggers in ms sql server?
What is the process of normalising?
What are the differences between char and nchar in ms sql server?
Explain error and transaction handling in sql server?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What are xml indexes?
What is sub-query in sql server? Explain its properties.
what are defaults? : Sql server database administration
How do you open a cluster administrator?
CLR Integration ? what is Notification services ?
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)