How would a user execute a series of SQL statements using a task?

Question

Options

• AInclude the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO
• BA stored procedure can have only one DML statement per stored procedure invocation and
• CUse a stored procedure executing multiple SQL statements and invoke the stored procedure from
• DCreate a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of

• A
  13% (5)
• B
  10% (4)
• C
  3% (1)
• D
  74% (29)

No community discussion yet for this question.