Microsoft Office Tutorials and References
In Depth Information
retrieving server status information stored in a database table
1.
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
2.
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
3.
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]
GO
CREATE PROCEDURE [dbo].[uspGetServerDetails]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
 
Search JabSto ::




Custom Search