declare @ProcID int
Select @ProcID = OBJECT_ID from  sys.procedures P where p.Name = 'ap_NewWarehouse'

SELECT syscolumns.Name AS ParamName, systypes.Name as DataType, syscolumns.length 
	FROM syscolumns INNER JOIN systypes ON syscolumns.xtype = systypes.xtype where 
	SysColumns.ID = @ProcID
	Order by syscolumns.Name