SAP HANA SQLScript · Imperative SQLScript: Variables, Flow & Cursors

How do you count the rows of a table variable, and how do you test whether it's empty, inside imperative code?

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Imperative SQLScript: Variables, Flow & Cursors

In SQLScript, why is a declarative SELECT usually faster than an imperative loop that produces the same result?

Reading :tv.title[99] when the table variable has only 10 rows — error, or something else? And writing to [99]?

With the table operator :tv.INSERT((…), <position>) (SPS 01+), what does supplying a position do versus omitting it?

A table variable has 3 rows, then :ot.UPDATE(('Update 4'), 4) runs. What is the result?

What does the OUTER block see for var1? ``` DECLARE var1 VARCHAR(10)='Outer'; BEGIN DECLARE var1 VARCHAR(10); var1 = 'Inner'; END; -- outer: SELECT :var1 ```

You move an IF EXISTS (SELECT …) check inside a WHILE loop that runs 10,000 times. What happens to runtime versus the same EXISTS in a declarative query?

Start learning today

Free to start — download the app or use it in your browser.