I came across something new for the first time today. Dynamic SQL with output parameters.
Here is how you do it in MSSQL.
DECLARE @totals INT
EXEC sp_executesql N’SELECT @totalCount = count(*) from sysobjects’, N’@totalCount INT OUTPUT’, @totals OUTPUT
print ‘Totals: ‘ + convert(varchar,@totals)
