DECLARE @id int

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TabellaIdentity]') AND type in (N'U'))
  CREATE TABLE TabellaIdentity
  (
    id int identity(1,1) primary key clustered,
    descri varchar(50)
  ) 

INSERT INTO TabellaIdentity (descri)
SELECT 'Prova'

SET @id = SCOPE_IDENTITY()

SELECT @id