Well, SQL Plus is a little awkward...

Koen (da-zero) (1/13/2011)

---

Great, but difficult question.

I had to read the section on converting binary string data on the MSDN page for CAST and CONVERT a few times to get it.

But...

Richard Sisk (1/11/2011)

---

Would have got it right except I was thrown by the apparent conflict that the question was for SQL Server 2008 but the last option clearly asks about...

SQL Server 2000 is not unsupported. Only the mainstream support has ended.

http://blogs.msdn.com/b/sqlreleaseservices/archive/2008/02/15/end-of-mainstream-support-for-sql-server-2005-sp1-and-sql-server-2000-sp4.aspx

Hi,

I almost got the question right, but failed because of the usage of index on computed columns.

I have tested it with the following script and the index seems to be...

I like the question, mostly because it focuses on one aspect only - the default size.

Too many times there are complicated questions which mix the question itself with ostacles and...

I think the question is very good as well, but I am not sure if the answer is correct.

I chose

Error: "Column name or number of supplied values does not...

Good Question, but not valid for all languages, since some have different date formats (ymd):

SELECT dateformat, name, alias FROM sys.syslanguages WHERE dateformat NOT LIKE '%y'

jeff.mason (12/2/2010)

---

It is not only that. Constraints should prevent invalid data updates no matter where they come...

Hm, this is a very good topic, and most answers make sense.

But the last one with the where clause for all inserts is nonsense. You cannot "enforce" uniqueness by...

You may have missed my 3rd post where I...

Ok, I think I finally arrived.

I thought the "comments" were the standalone extended properties / description of the stored procedures, constraints etc..

I did not consider the inline comments of the...

I think the wording "consists" was...

Are you sure about that? I can't see any comments in that view.

With regards to option...

No comment, next question... 🙂