Microsoft Office Tutorials and References
In Depth Information
retrieving server status information stored in a database table
Create a table named tblserverstatus with columns as shown in Figure 2-73 in the
Visioservices database you created earlier.
Figure 2-73. Server Status Table in SQL Server
populate a few rows of this table with information as shown in Figure 2-74 .
Figure 2-74. Populating rows with data for the server status table in SQL Server
Create a stored procedure named uspGetServerDetails that will execute the sQL query
to retrieve the values from the table in Figure 2-74 . Listing 2-2 shows the code.
Listing 2-2. The uspGetServerDetails Stored Procedure
USE [VisioServices]
CREATE PROCEDURE [dbo].[uspGetServerDetails]
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
Search JabSto ::

Custom Search