::CURRENT_LINE_NUMBER

SQLScript 过程、函数和触发器可以通过 ::CURRENT_LINE_NUMBER 返回当前语句的行号。

语法

::CURRENT_LINE_NUMBER

示例

示例代码1 create procedure proc_inner(out o int) as2 begin3 o = ::CURRENT_LINE_NUMBER;4 end; 示例代码1 create procedure proc_outer as2 begin3 declare a int;4 call proc_inner(a);5 select :a, ::CURRENT_LINE_NUMBER from dummy;6 end;7 call proc_outer;8 -- Returns [3, 5] 示例代码1 do begin2 declare a int = ::CURRENT_LINE_NUMBER;3 select :a, ::CURRENT_LINE_NUMBER + 1 from dummy;4 end;5 -- Returns [2, 3 + 1]