Integrating Visio with SharePoint - Visio Services Quick Guide - page 78

Figure 4-59. Server Status Table in SQL Server
Populate a few rows of information into this table, as shown in Figure 4-60 .
Figure 4-60. Populating 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 4-59 . Listing 4-2 shows
the code.
Listing 4-2. The uspGetServerDetails Stored Procedure
USE [VisioServices]
GO
/****** Object: StoredProcedure [dbo].[uspGetServerDetails]
Script Date: 10/18/2014 11:30:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO