使用Sp_executeSql执行SQL

declare@valvarchar(100)
declare@Sqlnvarchar(4000)
set@Sql='Set @val=5'
exec Sp_executeSql @Sql, N'@val varchar(100) output',@val output
select@valas Value