Answer Posted / guest
Use the OpenRowSet Function to Run a Query on a Remote SQL
Server.
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
how would you store your query in an SSRS report or a Database server?
Define self join?
Suggest a method of joining two tables.
What is the difference between dataadapter and datareader?
What are the triggers in sql?
What is buffer cash and log cache in sql server?
How many types of functions are there in sql server?
How can sql server instances be hidden?
How to automatically create a log when an exception is being received into SQL Server?
What is trace flag in sql server?
Differentiate between truncate vs delete in mssql?
Can group by and orderby be used together?
What is cursors?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is the difference between value type and reference type?