I ran into this lovely error today and it was because I’m still learning SQL. I guess sometimes you need to define ‘sp_executesql’ and this is what I ran into…

I had to declare the below information for the lovely error: 

"Procedure sp_executesql: expects parameter '@statement' of type 'ntext/nchar/nvarchar'" 
to disappear.

DECLARE @SQL NVARCHAR(100)
SET @SQL = 'SELECT TOP 1 * FROM sys.tables'
EXECUTE sp_executesql @SQL