🙂

Kenneth Fisher-475792 (2/13/2011)

---

This may have nothing to do with why you aren't seeing intellisense on some of your servers but it only works on SQL 2008+ servers. If...

This is good timing for that question: I was wondering why on some servers, I don't get intellisense in my query window.

Now, sqlcmd explains everything

Thanks for the...

vk-kirov (12/8/2010)

---

The result of the comparison "EmployeeID <> NULL" is undefined for all values of EmployeeID (unless you set the ANSI_NULLS option to OFF). So the result of the WHERE...

From the e-mail I received on Friday morning, the question was the original question, so it did not mention the "GUI" modification.

So, when I read the question, my answer was...

That one was easy for me wich proves that "Today's Question" works well for people like me because I applied things I learned from an earlier "Today's Question"... unless I...

OK!... I realize that there is much more things to think about before changing all table property to "cascade on delete". So I think I will ask for...

I am guessing that the 800 columns would be only numbers, am I wright? With 800 different columns? No repetitive (except for the two you mentioned) nor computered columns?

If...

Carl Federl (11/21/2010)

---

I know I have to make sure that all dependencies to that person are removed before I can do it.

Not necessarily - the foreign key constraints specification will...

I am realy lucky: I am having a...

My engish beeing what it is, I did also not get the differance between the first two answers, but that's ok. I learned something new and it is the important...

Hugo Kornelis (10/15/2010)

---

tilew-948340 (10/15/2010)

---

Hi Hugo.

The first time I tried the PERSISTED, I got the divide by zero error AFTER the "show table" wich does not seem to be, as I...

Hugo Kornelis (10/15/2010)

---

tilew-948340 (10/14/2010)

---

If you want to try it with PERSISTED, then just add PERSISTED at the end of the computed column...

Hardy21 (10/13/2010)

---

Good question.

If computed columns are persisted in nature (e.g. QTot AS QF1 + QF2 PERSISTED,) then you receive the error after "Insert Zeroes" print statement and "SELECT * FROM...

That was a realy trick question. Thank you Hugo for the explanation. I had to read it twice, but I finaly got it... Sure I know how a...

I got the wright answer because I knew that a char(50) would return 50, so thanks for the easy choice 🙂

My question now is: how someone know that "When...