Unlike the normal text code, the esProc code is written in the cellset (i.e. grid), as shown in the below:
esProc has an Excel-like grid user interface. With it, users can execute the codes in the grid from left to right, top to bottom. Each cell is named after the combination of its column and row numbers, which is unique and natural.
esProc users can reference the cell name directly, without defining any variables.
On the grid-style interface, codes are presented with natural format, natural alignment, and natural indentation, no deed to typeset. The grid-style presentation of codes not only makes the code neat and clean, but also offers the users an intuitive way to organize and arrange the relationship between the computing steps.
Based on step-by-step computing model, the grid-style code allows users to monitor, think, and write the codes from the business perspective.
The problem can then be solved step by step by decomposing the complex computing goal into several steps. Each step can reference the previous computing result.Meanwhile, the esProc users can benefit from the step-by-step mechanism to detect and correct errors easily.
Compared with esProc, SQL solution is more complex as it doesn't support step-by-step computing. Java/VB and other senior languages support step-by-step computing, but they are neither better at structured data process, nor the computing languages based on database . esProc is more advantageous, and has much simpler syntax.