Home » sql server error 116

sql server error 116

SQL Server Error : 116, Severity: 15. Only one expression can be specified in

SQL Server Error : 116 Details

SQL Server Error: 116 Severity: 15 Event Logged or not: No Description: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. Severity 15 Description: Indicates syntax errors in the Transact-SQL command.

Example:

SELECT [ID], [Date], [Description], [Count] FROM [dbo].[Order] WHERE [ID] NOT IN (SELECT [ID], [NumberofStock] FROM [dbo].[Stock]) Msg 116, Level 16, State 1, Line 4 Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

This error usually occurs when a sub-query is used in conjunction with the IN or NOT IN logical operator. The IN … Read the rest