Explanation and...

Explanation and examples can be found here: http://msdn.microsoft.com/en-us/library/ms177564.aspx

If you still have questions after that, feel...

demonfox (10/10/2012)

---

Lokesh Vij (10/10/2012)

---

I was hoping this too....Not every one got it correct!

Correct answers: 75%...

L' Eomot Inversé (10/10/2012)

---

Hugo Kornelis (10/10/2012)

---

However, the ANY keyword means that the expression has to be true for at least one of the values in the subquery. So if you...

The most important...

kapil190588 (10/10/2012)

---

Hi Hugo,

Ya i got the answer now..

So if a column is dropped from a base table which is using in view then it will throw an error..

but if after...

You can read about TRY ... CATCH here: http://msdn.microsoft.com/en-us/library/ms175976.aspx

In T-SQL, "Try Except" is invalid syntax....

kapil190588 (10/10/2012)

---

can anyone tell me how to add a constraint to a already created view?

I write as-

alter view chk_sales

as

select * from SalesDates,

add chk_unique constraint unique (id>2)

this is giving me...

ANY is not a very well known keyword, probably because it...

kapil190588 (10/10/2012)

---

Hi Hugo,

according to another QOD i.e view 5

there was condition that if a add a new column to the table (previously there were 5 columns) and didnt refresh the...

kapil190588 (10/9/2012)

---

why query for step 2 result only 5 rows--

What will the original SELECT * FROM VOrder_Details (Step 2 above) statement return when executed?

As, I think that when we...

tilew-948340 (10/8/2012)Just to let you know that also some people reading the QotD might never use anything else then the SSMS because... well... not every one is a professionnal in...

But server defaults can be changed. Not that there is much in doing so (read on!), but it can...

I really liked the question. Unlike Tom, I even liked the inclusion of all the settings, and I don't think it's a red herring. This question is about knowing all...

SELECT user_access, user_access_desc

FROM sys.databases

WHERE name = 'YourDatabase';