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