Another case of unclear question.

Will this code execute and return a result from one of the stored procedures?

Both

3. No, this will create an infinite loop (until the limitations of...

Nice question but inserts suppose to be separated by "GO". Otherwise no one would be performed.

My first impression about this question was very negative.

Question itself is not clear and right answer is definitely "false". It is a disaster to have an interview with somebody who...

One more good question you need to think about twice before answer selection!

Thanks!

This QOtD didn't give you a chance for correct answer. It should be removed and answers should be disregarded.

My first opinion was: very exotic question far away from practical usage.

But later I changed my minds. Never thought about arithmetical operations in T-SQl work in such way. Thanks...

What's why I always try to avoid nullable columns or make something like that:

select * from dbo.Employees where EmployeeID

not in (SELECT isnull(NullableColumn,0)...

Very nice question. And one more time I see that 'isnumeric' works in a way which is far away from our expectations. Always used custom made functions instead.

It is real joy to answer such questions. I was able to look at so usual command from another point, turn on common logic and get it right. But I...

This is really exciting question.

I always had feelings that /* */ has priority on – . And construction like -- /* will lead SQL to ignore /*.

I was wrong!...

We have situation when answer is correct but question is careless.

One of the conditions is: "Note: you other applications that connect to this server appear to be working fine."

As...