SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC | Journey to SQL Authority with Pinal Dave

Common Properties of SP_EXECUTESQL and EXECUTE/EXEC The Transact-SQL statements in the sp_executesql or EXECUTE string are not compiled into an execution plan until sp_executesql or the EXECUTE statement are executed. The strings are not parsed or checked for errors until they are executed. The names referenced in the strings are not resolved until they are… Continue Reading...

Source: SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC | Journey to SQL Authority with Pinal Dave