Someone revived this thread again today after another two years. But I think I might as well throw my bit in anyway, so that someone who comes here...

Alvin Ramard (7/30/2014)

---

Luis Cazares (7/30/2014)

---

Eirikur Eiriksson (7/30/2014)

---

Guess shrinked is the...

I agree withGary's first comment above; views are not a patch on stored procedures as a mechanism for preotecting the schema from becoming frozen/unchangeable because the apps depend on knowing...

Koen Verbeeck (7/31/2014)

---

+1. Dead easy once you know which column you need.

Still...

Puisque c'est toi qui l'as écrit, je choisirai é :-D.

not so random word: sinner

Nice question, correct answer, appallingly wrong explanation.

The reason this works is nothing to do with scope (which isn't the batch unless the declaration is the first statement in the batch,...

é or ê?

Ed Wagner (7/29/2014)

---

My DBCC Timewarp has malfunctioned and Koen cracked the crystal ball (after getting it from Lynn, who got it from Grant), so you'll have to take your best...

Jeff Moden (7/29/2014)

---

Ok... I'm going to have to check the house for hidden cameras. That's a picture of me doing a code...

But which music is grounded in three discords and a white lie?

Sean Lange (7/29/2014)

---

Actually normalization (more tables) causes slower performance. That is the nature of the beast. However, in a relational database such as this you want to normalize. When designing...

Lynn Pettis (7/28/2014)

---

The Dixie Flatline (7/28/2014)

---

I respect and admire all you guys for your professionalism, and often restraint, in dealing with all manner of questions. Steve does...

Ed Wagner (7/28/2014)

---

Several years...

It hasn't tested my insanity yet, I...

Jason Selburg (7/25/2014)

---

Wrap your conditions in parenthesis and add an OR

CREATE TABLE CheckConstraintTest

(

CTId INT NOT NULL ,

...