Nice and easy one. Initially I overlooked the word WTH and answered the question. After seeing the explaination only i realised it was mispelled and it will act as alias...

After reading BOL twice, Got some knowledge about it ..

I'm slightly confused with Level mentioned in example B (BOL) . But anyway I managed get it correct..

A straight forward question..

If somebody explains step by step on actually what happening will be very helpful..

+1

I thought EXECUTE statement will change the DB.

Learning for me.

I got it correct, Not because i'm staying in India. As Hugo and others said, In the given options SYSUTCDATETIME ( ) is the only option which will return such...

Nice question..

Please some one list the limitations of schema binding a view.

Hi mani,

Thanks for spending your time to explain about schema Binding.

manik123 (2/7/2013)

---

If MyView is schema bind no one will be able to alter the dbo.MyTable table unless they drop...

Nice and easy one one.

I got a second thought whether there is any database level set option to make a view referesh automatically.. finally I ensured there is no...

Raghavendra Mudugal (2/6/2013)

---

so, if no brackets then just start from L to R no matter what the operator is... and in the above given equation we don't know where to...

Hugo Kornelis (2/6/2013)

---

You could have saved that time. I just checked...

Previous one was quite simple expression. This one with some complex expression..

We can consider this as series of question..:-)

Nice & easy one.

But you steal some of my time by making me to sit and calculate each and every statement..:-) .