Using xp_srv_paraminfo_sample

The xp_srv_paraminfo_sample extended stored procedure (in Xp_param.dll) accepts parameters from a Transact-SQL statement, analyzes each parameter, and posts a result set to the client containing information about each parameter and parameter value. The Transact-SQL script Xp_sample.sql installs and runs the extended stored procedure.

DECLARE @CategoryID int

DECLARE @CategoryName varchar(15)

DECLARE @Description nvarchar(50)

DECLARE @OrderDate datetime

DECLARE @Discount real

  

SELECT @CategoryID = 7

SELECT @CategoryName = 'Produce'

SELECT @Description = 'Dried fruit and bean curd'

SELECT @OrderDate = 'April 22, 1997'

SELECT @Discount = .025

  

EXEC xp_srv_paraminfo_sample @CategoryID OUTPUT, @CategoryName,

    @Description OUTPUT, @OrderDate, @Discount OUTPUT

GO

  

This is in a sample only available if you select Dev Tools during setup.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.