Create Record Layout

[devon59]

Hi there,
Is there any easy way that I could get all columns data type for my output instead of me having to go through each variable and look at them one by one? I'm looking for something similar to
Proc contents in SAS.
Thank you

 

[SQLDenis]

for a stored procedure use this example

USE pubs
Go
SELECT SPECIFIC_NAME as PROCEDURE_NAME,PARAMETER_NAME,DATA_TYPE,* FROM INFORMATION_SCHEMA.PARAMETERS
WHERE SPECIFIC_NAME = 'reptq3'
ORDER BY ORDINAL_POSITION

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/