You may get the below error while executing sp_executesql:
EXEC sp_executesql N'SELECT GetDate()'
Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1
Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.
To solve this error add N before the query:
