CREATE TABLE  Tables(
    [SID] [numeric](12, 0) IDENTITY(1,1) NOT NULL,
    [UpdateTime] [datetime] NOT NULL,
 CONSTRAINT [PK_Tables] PRIMARY KEY (SID  ASC) 
)  

declare  @myseq numeric(12) 
insert into Tables (UpdateTime) values(getdate()) 
set @myseq = scope_identity() 
delete from Tables where sid=@myseq
 select @myseq