Mega Code Archive
Execute a dynamic statement and return the result with OUTPUT
4>
5> DECLARE @sql AS NVARCHAR(12), @i AS INT
6>
7> SET @sql = N'SET @p = 10;';
8>
9> EXEC sp_executesql
10> @stmt = @sql,
11> @params = N'@p AS INT OUTPUT',
12> @p = @i OUTPUT;
13>
14> SELECT @i;
15> GO
-----------
10