Code Inspections in SQL server
This topic lists all JetBrains Rider code inspections available in SQL server.
You can toggle specific inspections or change their severity level on the Editor | Inspection Settings | Inspection Severity | Other Languages settings page CtrlAlt0S.
Inspection | Description | Default Severity |
---|---|---|
Builtin functions | Reports truncations of string arguments in ISNULL functions. The ISNULL syntax is According to ISNULL at docs.microsoft.com, Example (Microsoft SQL Server):
| |
ORDER BY in queries | Reports usages when the For more information about usages of Example (Microsoft SQL server):
In a subquery, ORDER BY will be highlighted as an error. You can add TOP, OFFSET, or FOR XML to a subquery. Alternatively, use the Delete element quick-fix to delete the ORDER BY section. After the quick-fix is applied:
|