SQL Uncategorized Flashcards
1
Q
CALL
A
Calls astored procedure.
2
Q
CALL (with Anonymous Procedure)
A
Creates and calls an anonymousprocedure.
3
Q
EXECUTE IMMEDIATE
A
Executes a string that contains a SQL statement or aSnowflake Scripting statement.
4
Q
EXECUTE TASK
A
Manually triggers an asynchronous single run of a scheduled task (either a standalone task or the root task in aDAG (directed acyclic graph)of tasks) independent of the schedule defined for the task.
5
Q
EXPLAIN
A
Returns the logical execution plan for the specified SQL statement.