ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How to Run a Query on a Remote SQL Server?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to Run a Query on a Remote SQL Server?
Answer
# 1
Use the OpenRowSet Function to Run a Query on a Remote SQL 
Server.
 
Is This Answer Correct ?    1 Yes 2 No
Guest
 
  Re: How to Run a Query on a Remote SQL Server?
Answer
# 2
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 ?    2 Yes 0 No
Vinod
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table. Techno-Solutions2
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2 HCL2
What is an execution plan? When would you use it? How would you view the execution plan?  1
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.  1
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?  1
what is mean by crystal repoart? ahere we will mainly use that?  1
What are the two types of concurrency?  2
What is the basic functions for master, msdb, tempdb databases? CSC2
What is a table called, if it does not have neither Cluster nor Non-cluster Index?  1
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?  1
How to Debug a Stored Procedure? Allianz4
how can i store resumes in database? HCL2
What are primary keys and foreign keys?  3
When do we use the UPDATE_STATISTICS command?  3
How to create logins using windows Authentication mode?  2
what are batch in sql server? Satyam2
What is a stored procedure?  3
What are sub-queries? Give example? In which case sub-queries are not feasible? Infosys3
What are the pros and cons of creating extended stored procedures?  1
Can you have a nested transaction? HCL3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com