Home Forums SQL Server 2008 T-SQL (SS2K8) how to store result at variable? RE: how to store result at variable?

  • August 1, 2013 at 5:55 am

    #1637742

    create proc sp_temp

    @count INT = NULL OUTPUT

    as

    begin

    declare @Result varchar(5)

    select @count = COUNT(*) from #temptable

    end

    Try this out