USE yourDB
SELECT a.name AS p_name,b.name AS p_type,a.length AS p_length,a.isoutparam AS p_isout
FROM syscolumns a, systypes b
WHERE b.name<>'sysname' AND a.xtype=b.xtype AND id = (select id from sysobjects where name = 'SalesByCategory')
SELECT a.name AS p_name,b.name AS p_type,a.length AS p_length,a.isoutparam AS p_isout
FROM syscolumns a, systypes b
WHERE b.name<>'sysname' AND a.xtype=b.xtype AND id = (select id from sysobjects where name = 'SalesByCategory')