Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’

Ekrem Önsoy

5 years ago

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:

DECLARE @command VARCHAR(150)
SET @command = 'SELECT * FROM MYTABLE'
EXEC sp_executesql @command

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:

EXEC sp_executesql 'SELECT * FROM MYTABLE'

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:

DECLARE @command NVARCHAR(150)
SET @command= N'SELECT * FROM MYTABLE'
EXEC sp_executesql @command

DECLARE @command NVARCHAR(150)

SET @command= N'SELECT * FROM MYTABLE'

EXEC sp_executesql @command

and

EXEC sp_executesql N'SELECT * FROM MYTABLE'

1	EXEC sp_executesql N'SELECT * FROM MYTABLE'