Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE:
“Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’.”
EXPLANATION:
You may see this error message when you run the command in a variable with the sp_executesql system SP.
Example:
1 2 3 | DECLARE @command VARCHAR(150) SET @command = 'SELECT * FROM MYTABLE' EXEC sp_executesql @command |
Or if you run a command directly without using any variables, you will see the same error message:
1 | EXEC sp_executesql 'SELECT * FROM MYTABLE' |
SOLUTION:
In fact, the error is clearly written in the error message. The @statement parameter that you will use for the sp_executesql system SP should be UNICODE.
The correct versions of the above examples are as follows:
1 2 3 | DECLARE @command NVARCHAR(150) SET @command= N'SELECT * FROM MYTABLE' EXEC sp_executesql @command |
and
1 | EXEC sp_executesql N'SELECT * FROM MYTABLE' |
