How to Run a Query on a Remote SQL Server?
Answers were Sorted based on User's Feedback
Answer / vinod
By Using linked server we can get data from remote servers, and we can fire a query on remote server. we need to use three part naming conventions for this.
servername.databasename.dbo.tablename
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
Use the OpenRowSet Function to Run a Query on a Remote SQL
Server.
| Is This Answer Correct ? | 1 Yes | 4 No |
What is 'Join' and explain its various types.
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Can we use max in where clause?
What is indexed view? How to create it?
when would you go for denormalization? : Sql server database administration
What happens if date-only values are provided as date and time literals?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
How do you Implement SSIS Packages in your Project?
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
Explain comment on transactions?
How real and float literal values are rounded?
wat is the main diff between sql server 2000and sql server 2005
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)