JAcRrSBp

1if not exists (select * from sys.tables t where t.name = 'Persons')
2CREATE TABLE Persons (
3    ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
4    LastName varchar(255) NOT NULL,
5    FirstName varchar(255),
6    Age int);
7
8	Begin tran
9
10	insert into dbo.Persons(LastName,FirstName,Age)
11	values ('test','test',35)
12		insert into dbo.Persons(LastName,FirstName,Age)
13	values ('test','test',35)
14		insert into dbo.Persons(LastName,FirstName,Age)
15	values ('test','test',35)
16
17	rollback tran
18
19	Begin tran
20		insert into dbo.Persons(LastName,FirstName,Age)
21	values ('test','test',35)
22	select @@IDENTITY as 'lastidentity'
23
24	commit tran
25
26	select count(*) as numberOfRecords from dbo.Persons
27
28	drop table.dbo.Persons