Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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