execute

execute (N'select * from Student')--正确

execute ('select * from Student')--正确

-------------------------------------------------------

sp_executesql

sp_executesql N'select * from Student'--正确

sp_executesql 'select * from Student'--错误     sp_executesql 只能执行Unicode或可以隐式转换为ntext的字符串常量、变量。