declare @t int exec sp_executesql N'select @x=count(*) from a' ,N'@x int output',@x=@t output print @t