A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
Sql does not have async or parallel support. The sp_executesql will send all its result rows to the client before the next statement.