The following syntax allows you to define columns in various parts of the procedure, such as table variable declarations. 

<column_name> <data_type>(<p>, <s>)
procedure_name
Specifies the name of the procedure to be called by the application.
data_type
Specifies the data type, including the precision and scale, for the results of the function. See "Data types syntax" for a complete list of supported data types.