2.1.1.21 E182, Module language

  • Article
  • 2 minutes to read

V0021:

The specification states the following:

 Clause 13, "SQL-client modules"
  
 Subclause 13.1, "<SQL-client module definition>":
  
 <SQL-client module definition> ::=
 <module name clause> <language clause> <module authorization clause>
 [ <module path specification> ]
 [ <module transform group specification> ]
 [ <module collations> ]
 [ <temporary table declaration>... ]
 <module contents>...
  
 <module authorization clause> ::=
 SCHEMA <schema name>
 | AUTHORIZATION <module authorization identifier>
 [ FOR STATIC { ONLY | AND DYNAMIC } ]
 | SCHEMA <schema name> AUTHORIZATION <module authorization identifier>
 [ FOR STATIC { ONLY | AND DYNAMIC } ]

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. Transact-SQL supports embedded language features instead.