Sorry, seems something not clear in this question, in the Question (select 4) what it means

i am choosing 2 3 5 it say i am wrong

if object_id('test2') is not null

drop table test2

if object_id('test1') is not null

drop table test1

create table test1 (a int not null primary key);

create table test2 (b int,a int )

GO

--statement 1

insert into test1

output inserted.a

select 1

GO

--statement 2

create trigger trig_test1

on test1 after insert

as

select 2

GO

--statement 3

insert into test1

select 3

GO

--statement 4

insert into test1

output inserted.a

select 4

GO

--statement 5

declare @temp as table (b int)

insert into test1

output inserted.a

into @temp

select 5

select * from @temp

GO

So what is statement 1

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]