All Forums General
Prabhu_Teradata 17 posts Joined 06/12
12 Jul 2012
Declaring Variable in Teradata Stored procedure

Is it possible to declare variable in the following way in Teradata SP

 

SET Variable_name = select column_detail from table where some condition

 

Here the select will return only one value

 

Teradata Version: 12

Thanks, Prabhu
WAQ 158 posts Joined 02/10
13 Jul 2012

What about

SELECT col_name INTO variable_name

WAQ 158 posts Joined 02/10
13 Jul 2012

DECLARE variable_name VARCHAR(20);

SELECT col_name INTO variable_name...

You must sign in to leave a comment.