Can you link only other SQL Servers or any database servers
such as Oracle?
Answer / guest
We can link any server provided we have the OLE-DB provider
from Microsoft to allow a link. For Oracle we have a OLE-DB
provider for oracle that microsoft provides to add it as a
linked server to the sql server group.
| Is This Answer Correct ? | 4 Yes | 0 No |
How you can move data or databases between servers and databases in sql server?
What is not null constraint?
CREATE a table from another table
What is difference between inner join and join?
What are synonyms?
What is Schema? and why we use schemas?
Why should we go for stored procedures? Why not direct queries?
How to list all field names in the result set using mssql_field_name()?
What is @@error in sql?
What is lock escalation?
What is sub-query in sql server? Explain its properties.
check, not null,unique
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)