执行SQL语句并返回值

 declare @Counts int
  set @Counts = 0
      if (@Counts>=0)
   begin
   declare @strTmp nvarchar(500)
   set @strTmp = ' SELECT @Counts= COUNT(*) FROM test WHERE 1=1'
   exec sp_executesql @strTmp,N'@Counts int out ',@Counts out
   end

  select @Counts