EXEC 三部曲

exec ''
exec ('')
exec ('select * from db.dbo.table') at linkserver

sp_executesql 三部曲

sp_executesql N'SELECT 1'

sp_executesql N'SELECT @p'
,N'@p varchar(3)'
,@p=1

EXECUTE sp_executesql N'select @p1,@p2'
, N'@p1 varchar(10) ,@p2 varchar(10)'
, @p1 = '1111', @p2 = '222'

linkserver.master.dbo.sp_executesql N'SELECT @p'
,N'@p varchar(3)'
,@p=1
*一定要是N''

More

exec VS sp_executesql
https://www.itread01.com/content/1496982017.html