The xp_hello extended stored procedure (in Xp_hello.dll) accepts one output parameter, sets the output parameter to “Hello world”, and displays one row containing that same string. This is in a sample only available if you select Dev Tools during setup.
DECLARE @txt varchar(33)
EXECUTE xp_hello @txt OUTPUT
SELECT @txt AS OUTPUT_Parameter
Extended Stored Procedure Sample: xp_hello