Odd SSCrazy:

When I do the test with select:

declare @Runtime table (

Version int,

Runtime int)

declare @Start datetime, @X int

select @start = getdate()

select top 100 * from b_order

insert into @Runtime (version, runtime)

select 1, datediff(ms, @start, getdate())

begin try

select @start = getdate()

select top 100 * from b_order

insert into @Runtime (version, runtime)

select 2, datediff(ms, @start, getdate())

end try

begin catch

the result I got is

version runtime

1 0

2 30

(average result)

When I use "select top 1000 * from b_order"

the result I got is

version runtime

1 390

2 420

When I use "select top 10000 * from b_order"

the result I got is

version runtime

1 700

2 717

Seems there's some overhead for try..catach, is it?

Elton