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 to handle errors in Stored Procedures.
find the 3rd max salary
Find first and last day of current month in sql server
write the query for find the top 2 highest salary in sql server
36 Answers Cranes, Jayanti Software, Medi Assist, Rmax, TCS,
What are defaults? Is there a column to which a default can't be bound?
Can we drop user if user mapped to any logins
What is the architecture of ms sql reporting service?
What are the advantages of partitioning?
How can we delete a table in sql server?
What is dbcc? Give few examples.
What do you think of this implementation? Can this be implemented better?
What are different types of join?
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)