What is the difference between OLEDB and ODBC
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / padma
OpenDatabaseConnectivity is a microsoft standard for
connecting to relational databases.
Advanced version of ODBC is OLE DB
Is This Answer Correct ? | 22 Yes | 6 No |
What are the benefits of filtered indexes?
How do you fine the performance tunning?
How to delete duplicate rows?
How to swap the data of two columns in a table. both the columns containing varchar values.
What is normalization and what are the advantages of it?
What are different types of Keys? Please explain all the keys with a suitable example.
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Which data type columns are the best candidates for full-text indexing?
Define inner join in sql server joins?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Why do we use functions?
What is a sql join?