Although there's nothing in the relational model to prevent you from having count constraints on a table, the only table level constraints supported by SQL are foreign key, primary key...

Richard Warr (2/13/2014)

---

Excellent point - if using NVARCHAR the query also returns the...

butter (familiam non alunt verba)

Ed Wagner (2/12/2014)

---

sing4you (2/12/2014)

---

crookj (2/12/2014)

---

L' Eomot Inversé (2/12/2014)

---

whereisSQL? (2/12/2014)

---

SQLRNNR (2/12/2014)

---

Ed Wagner (2/12/2014)

---

Revenant (2/12/2014)

---

JAZZ Master (2/12/2014)

---

crookj (2/12/2014)

---

Daniel Bowlin (2/12/2014)

---

SQLRNNR (2/12/2014)

---

Ed Wagner (2/12/2014)

---

BWFC (2/12/2014)

---

whereisSQL? (2/11/2014)

---

SQLRNNR (2/11/2014)

---

Lynn Pettis (2/11/2014)

---

Seventh Heaven! (All this delicious...

mtucker-732014 (2/12/2014)

---

L' Eomot Inversé (2/11/2014)

---

If it takes a weird question to get the...

Craig-315134 (2/11/2014)

---

... we allow our government to regulate all kinds of things it doesn't have the power to regulate.

Such as ... ?

Certainly I would rather have the federal government enforcing...

Craig-315134 (2/11/2014)

---

What I find funny is that the schools are teaching kids about the constitution, but telling lies about what the constitution means.

I suspect neither of us are constitutional scholars,...

SQLRNNR (2/8/2014)

---

I don't know if I'd prefer to see people in technology working only a few jobs during their careers, spending decades at each, or if we are better workers...

embroidery

complex {?why don't we have it?}

If it takes a weird question to get the candidate to think out...

Revenant (2/11/2014)

---

Ed Wagner (2/11/2014)

---

Kurt W. Zimmerman (2/11/2014)

---

jcrawf02 (2/11/2014)

---

Ed Wagner (2/11/2014)

---

BWFC (2/11/2014)

---

SQLRNNR (2/11/2014)

---

Ed Wagner (2/11/2014)

---

BWFC (2/11/2014)

---

Ed Wagner (2/11/2014)

---

SQLRNNR (2/10/2014)

---

Ed Wagner (2/10/2014)

---

SQLRNNR (2/10/2014)

---

Stuart Davies (2/10/2014)

---

Ed Wagner (2/10/2014)

---

crookj (2/10/2014)

---

Stuart Davies (2/10/2014)

---

BWFC (2/10/2014)

---

SQLRNNR (2/7/2014)

---

L'...

happycat59 (2/10/2014)

---

Rather than dropping/renaming tables, how about using the ALTER TABLE...SWITCH command. It will not leave you with any period when the table doesn't exist (SQL manages that for...

Wilbur Bud (2/10/2014)

---

I ran into this feature when I was building a stored procedure from a couple of code snippets that happened to use the same name for their temporary...

vineet_dubey1975 (2/10/2014)

---

drop in a loop makes the table inaccessible to external user? Can you share some e.g. how we can apply the loop that should i iterate through.

Thanks for the...