> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/about/compatibility-and-differences/sql_modemssql.md).

# SQL\_MODE=MSSQL

`SET SQL_MODE=MSSQL` implies all the following [sql\_mode](/docs/server/server-management/variables-and-modes/sql_mode.md) flags:

* [PIPES\_AS\_CONCAT](/docs/server/server-management/variables-and-modes/sql_mode.md)
* [ANSI\_QUOTES](/docs/server/server-management/variables-and-modes/sql_mode.md)
* [IGNORE\_SPACE](/docs/server/server-management/variables-and-modes/sql_mode.md)
* [NO\_KEY\_OPTIONS](/docs/server/server-management/variables-and-modes/sql_mode.md)
* [NO\_TABLE\_OPTIONS](/docs/server/server-management/variables-and-modes/sql_mode.md)
* [NO\_FIELD\_OPTIONS](/docs/server/server-management/variables-and-modes/sql_mode.md)

Setting the [sql\_mode](/docs/server/server-management/variables-and-modes/sql_mode.md) system variable to `MSSQL` allows the server to understand a small subset of Microsoft SQL Server's language. For the moment `MSSQL` mode only has limited functionality, but we plan to add more later according to demand.

## Supported Syntax in MSSQL Mode

### Using \[] for Quoting

One can use \[] instead of "" or \`\` for quoting [identifiers](/docs/server/reference/sql-structure/sql-language-structure/identifier-names.md):

```sql
SET SQL_MODE="MSSQL";
CREATE TABLE [t 1] ([a b] INT);
SHOW CREATE TABLE [t 1];
Table  Create Table
t 1    CREATE TABLE "t 1" (
  "a b" INT(11) DEFAULT NULL
)
```

You can use '\[' in identifiers. If you want to use ']' in identifiers\
you have to specify it twice.

## See Also

* [SQL\_MODE=ORACLE](/docs/release-notes/community-server/about/compatibility-and-differences/sql_modeoracle.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}