What is the difference between OLEDB and ODBC
Answer Posted / kranthi
ODBC-it is designed for connecting to relational databases.
However, OLE DB can access relational databases as well as
nonrelational databases.
| Is This Answer Correct ? | 30 Yes | 2 No |
Post New Answer View All Answers
How raid can influence database performance?
How efficient you are in oracle and SQL server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to remove duplicate rows from table except one?
What is in place upgrade in sql server?
what is the difference between openrowset and openquery?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to convert numeric expression data types using the cast() function?
Disadvantages of the indexes?
Can you index views?
What is temporary table in sql server? Why we use temp table?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
do you know how to configure db2 side of the application? : Sql server database administration