|
0 |
5 |
/( |
0 |
4 |
+ |
0 |
4 |
- |
0 |
20 |
)* |
100 |
0 |
커서를 선언후..
DECLARE CURS CURSOR READ_ONLY
FOR
SELECT {{위테이블}}
OPEN CURS
DECLARE @OPERATOR VARCHAR(10)
DECLARE @CONSTANT NUMERIC(20,5)
DECLARE @VARIABLE_VALUE NUMERIC(20,5)
DECLARE @EXPRESSION varchar(1000)
FETCH NEXT FROM CURS INTO @OPERATOR, @CONSTANT, @VARIABLE_VALUE
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
SET @EXPRESSION = @EXPRESSION + @OPERATOR + ' '+ CONVERT(VARCHAR(100) ,@CONSTANT + @VARIABLE_VALUE)
PRINT @OPERATOR + ' '+ CONVERT(VARCHAR(100) ,@CONSTANT + @VARIABLE_VALUE)
PRINT @EXPRESSION
END
FETCH NEXT FROM CURS INTO @OPERATOR, @CONSTANT, @VARIABLE_VALUE
END
PRINT @EXPRESSION
CLOSE CURS
DEALLOCATE CURS
결과
------------------------------
5.00000
/( 4.00000
+ 4.00000
- 20.00000
)* 100.00000
------------------------------
왜 @EXPRESSION 에 누적이 안되는걸까요? 빈공간으로만 찍힘..
|