SELECT options refine results As we saw in the last article, the SQL SELECT statement has the widest variety of query options, which are used to control the way data is returned. These options ...

In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...

Is there any way to make a single SQL Statement in a Stored Proc continue after an error is raised by the system? For example, let's say I'm updating 100 rows in a ...

The value is returned through the macro variable SQLRC (a short form for SQL return code). For example, if a SELECT statement is valid, the macro variable SQLRC returns a value of 0. See Using Macro ...