Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.
Collapse the table of content
Expand the table of content

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.

Community Additions

ADD
Show:
© 2015 Microsoft