The stored procedure or scalar function <Name> cannot be specified as a FROM clause reference or as a target for an UPDATE, INSERT or DELETE statement.
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

The stored procedure or scalar function <Name> cannot be specified as a FROM clause reference or as a target for an UPDATE, INSERT or DELETE statement.

You cannot specify either a stored procedure or a scalar function as a reference in a FROM clause. For example, FROM sp_myproc() is a SQL error because the FROM clause must reference a table source (such as a table, view, rowset function, user-defined function, derived table, or joined table).

Also, you cannot specify either a stored procedure or a scalar function as a target for an UPDATE, INSERT, or DELETE statement. For example, UPDATE sp_myproc() is a SQL error because the UPDATE clause must target a table, a view, or an inline function.

  1. Remove the SQL statement that references the stored procedure or scalar function.

Show:
© 2016 Microsoft