Predict output

Question

Post reply

Predict output

Viewing 10 posts - 46 through 54 (of 54 total)

You must be logged in to reply to this topic. Login to reply

wim.buyens Ten Centuries Points: 1159 More actions · Answer 1

the select only returns 1 2 4 5 .

this is an exception is not returned by the select, so actually i don't feel this is a good question.

I knew which one to choose but it's not 100% correct.

ColdCoffee SSC-Dedicated Points: 39971 More actions · Answer 2

Mohammad Irfan-488206 (1/28/2010)
Output answer should be
1
2
4
5
why this option was not there??

I guess u did not look up at the "Messages" tab in the Results Pane..

For those intending to get the exact answer given in the choices, run this code

set nocount on

drop table #temp

declare @i int, @j-2 int

set @i = 1

create table #temp (id int)

while (@i<=5)

begin

begin try

begin transaction

if (@i = 3)

set @j-2 = @i/0

insert into #temp values (@i)

print cast (@i as varchar(5))

commit transaction

end try

begin catch

rollback transaction

print 'this is an exception';

end catch

set @i = @i + 1

end

Excellent question to learn exception-catching in a loop...

HardCoder Ten Centuries Points: 1045 More actions · Answer 3

COldCoffee (1/29/2010)
Mohammad Irfan-488206 (1/28/2010)
Output answer should be
1
2
4
5
why this option was not there??
I guess u did not look up at the "Messages" tab in the Results Pane..
For those intending to get the exact answer given in the choices, run this code
set nocount on
drop table #temp
declare @i int, @j-2 int
set @i = 1
create table #temp (id int)
while (@i<=5)
begin
begin try
begin transaction
if (@i = 3)
set @j-2 = @i/0
insert into #temp values (@i)
print cast (@i as varchar(5))
commit transaction
end try
begin catch
rollback transaction
print 'this is an exception';
end catch
set @i = @i + 1
end
Excellent question to learn exception-catching in a loop...

Ok thanks, but the question was about what will be the output, not message, else you may get many messages like 1 row affected...

Mohammad Irfan
http://matespoint.blogspot.com
http://www.irfit.com

Shahd Ansari SSC Journeyman Points: 79 More actions · Answer 4

Hi, This question havn't right answer.

at condition when i = 3 then exception will be occur , in that case transaction not commit and rollback in catch block, so that record will not inter in the #temp..

That why Select * from # Temp, will give the following answer...

1

2

4

5

Please Check you question and answer before post.

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 5

The answer is arguably correct since an exception occurs and is handled in the code. The order of what appears, and where, depends on your client.

The question has been edited to separate out "results" and "messages"

srinivas.thadem Grasshopper Points: 16 More actions · Answer 6

I really disagrree with the answer 1245.

the actual resul it is 12345.

if @i = 3 then we are setting J = @i/0;

so there no use of this statement finally we are storing the i value in to the temparory table.

Fatal Exception Error SSChasing Mays Points: 609 More actions · Answer 7

srinivas.thadem (2/2/2010)
I really disagrree with the answer 1245.
the actual resul it is 12345.
if @i = 3 then we are setting J = @i/0;
so there no use of this statement finally we are storing the i value in to the temparory table.

You can't divide by 0.... unless your name is Chuck Norris.

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 8

I like to think of the right answer as being the one "closest" to being right, which was the right answer which I chose despite knowing that the output did not look exactly correct but could not possibly be the other choices in any order.

Another good exercise for the kiddies in class! Keep those QOTD's coming!

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

Paul White SSC Guru Points: 150467 More actions · Answer 9

Liked the use of TRY...CATCH (though checking XACT_STATE would be cool).

Disliked the loop.

On balance: not bad.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 10

A poorly worded trick question.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/