@@identity not returning any value [resolved]

[thebloke]

combined both and it works:

CREATE PROCEDURE spVan_Start AS

SET NoCount On

insert into tblVan_counter (q1) values (1)

select SCOPE_IDENTITY()
GO

Thanks guys