ColumnStore Create Procedure
Creates a stored routine in ColumnStore.
Syntax
ColumnStore currently accepts definition of stored procedures with only input arguments and a single SELECT query while in Operating Mode = 1 (VTABLE mode). However, while in the Operating Mode = 0 (TABLE mode), ColumnStore will allow additional complex definition of stored procedures (i.e., OUT parameter, declare, cursors,etc.)
See Operating Mode for information on Operating Modes
images here
The following statements create and call the sp_complex_variable stored procedure:
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?