Good question - but what's up with the word "other" in the question?

That is, apparently, what happens...

davidandrews13 (3/27/2012)

---

bitbucket-25253 (3/27/2012)

---

davidandrews13 (3/27/2012)

---

surely it doesn't matter if you do SELECT *?

every time i create or update...

davidandrews13 (3/27/2012)

---

i dont, no.

to create a view I right-click teh 'Views' node in Object Explorer and click 'New View...'. I then click to 'Close' the dialog box that asks me...

It definitely matters. In the case of this question, you get an error either way. But in an earliers message, I...

palotaiarpad (3/27/2012)

---

I'm a bit confused.

BOL: If a view is not created with the SCHEMABINDING clause, sp_refreshview should be run when changes are made to the objects underlying the view that...

I think you can believe both.

SSMS and BOL give you the...

Sorry,...

kaspencer (3/22/2012)

---

A message to Steve Jones: Steve, appoint a named reader of every QotD before questions are used on the site. Otherwise, SACK those question-writers who do not read their...

Yes, as GSquared already shows.

However, there are (as far as I know) no...

venoym (3/21/2012)

---

Hugo Kornelis (3/21/2012)

---

Nice question on a little known (and, frankly, barely useful) feature.

Too bad it is hampered by the all too common mistake of depending on a time format....

Nice question on a little known (and, frankly, barely useful) feature.

Too bad it is hampered by the all too common mistake of depending on a time format. In some regions...

Put simply, WITH CHECK means that rows that are inserted or updated through the view must still satisfy the...

A good, solid question. Too bad it's only worth 1 point, I think 2 points would have been called for here.

tilew-948340 (3/10/2012)

---

Since then, I put only "SELECT" permission on the...

I am embarassed to admit that I got this question, that apparently was based on my comments, wrong.

I should have been warned. I even checked the code several times. All...