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.