Export (0) Print
Expand All

Parameter <name> specified where a table name is required. (Error 3216)

You created a parameter query that specifies an invalid parameter type. The following example produces this error.

PARAMETERS Param1 Text;

INSERT INTO Param1

SELECT *

FROM Customers;

Param1
is a text parameter, but the INSERT INTO statement expects a table name.

Change the parameter type from Text to TableID, and then try the operation again.



Community Additions

Show:
© 2014 Microsoft