RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Access DB
Enterprise Issues Business Rules
«Prev
Next»
Business Rules
Transaction Locking
Define Transactions
Three Transactions Modes
Define Isolation Levels
Identify Nested Transactions
Transaction Isolation - Quiz
Optimistic Pessimistic Locking
Deadlock Transaction Blocking
Avoid Server Deadlocks
Commit Rollback Transaction
Manage Distributed Tx
Error Handling Testing
Transaction Locking Conclusion
Server Interaction
Assign Use Variables
SQL Server Functions
SQL Function Statements
Date Time Functions
Reporting Errors
SQL Raising Errors
Programming Concepts Conclusion
SQL-Server Triggers
Trigger SQL Server Utility
Three Trigger Types
Enforcing Business Rules
Creating SQL Triggers
Practice Creating Triggers
Creating Triggers - Exercise
Implementing SQL-Server-Triggers
Modifying Triggers
Deleting SQL-Server Triggers
Testing SQL-Server Trigger
SQL Trigger Conclusion
SQL Triggers-Quiz
Stored Procedures
What is SP
Enforcing Business Rules
Creating SP
User Defined SP
Stored Procedures - Exercise
Modifying Procedures
Deleting Stored Procedures
System Extended SP
Error Handling
Using Output Parameters
Executing Stored Procedures
Testing Stored Procedures
Different SP Conclusion
Stored Procedure - Quiz
Accessing Remote Data
Enterprise Manager Server
Adding Remote Login
Accessing Remote Data - Exercise
Accessing remote data with Linked Server
Objective:
Practice adding a linked server and accessing a remote stored procedure.
Exercise Scoring
This exercise is worth a total of 25 points. You will receive up to 25 points for accurately creating the Transact-SQL statement that does the following:
Adds a linked server
Executes a remote stored procedure on the linked server
Instructions
Assume that you are connected to a server named Washington. First, construct a Transact-SQL statement to add Boston as a linked server to Washington. Second, write a line of code that executes a remote stored procedure, called
usp_GetSalary,
located on the Boston server in the Employees database, owned by
dbo
. The
usp_GetSalary
stored procedure accepts one argument, which is the ID of the employee. In your SQL statement, pass the value of
205
for this parameter.
Submitting the exercise
Type or paste your Transact-SQL statement into the text box below, then click the
Submit
button to submit it and view a results page.