Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1

When you try to execute sp_executesql you get the below error:


Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1
Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’.

Fix:
Add N Before the sql query.

Before:
[sql]
EXEC sp_executesql ‘SELECT 1′
[/sql]

After:
[sql]
EXEC sp_executesql N’SELECT 1’
[/sql]

Applies to SQL Server 2000,SQL Server 2005,SQL Server 2008,SQL Server 2008 r2,SQL Server 2012, SSIS