Nice question. thanks

Nice question. But little bit lengthy code.

Excellent question with nice explanation. Keep posting

Yes you are right.I have verified with temp table.

Thanks for nice question.

---Statement 1

CREATE TABLE #table1

(

ID int PRIMARY KEY,

Name varchar(20)

CONSTRAINT UN_Name UNIQUE(Name)

);

CREATE TABLE #table2

(

ID int PRIMARY KEY,

PersonName varchar(30) REFERENCES #table1(Name)

);

go

select * from #table1

select * from #table2

drop...

Nice question and nice explanation

i did not like the question because of insufficient information was provided.

"Must include an ORDER BY clause when a TOP clause is specified"

I feel this statement is wrong.

"Must include TOP clause when an order by is specified"

this is correct.other wise will...

Thanks for great question. Please keep on posting QOTD Ron. You question and answers are always good.

Thanks for simple question. RAID is applicable for other databases also. Thanks for author for providing the wiki link.

Wishing happy new YEAR TO ALL

Easy one.

http://www.sqlservercentral.com/Forums/Topic938337-149-1.aspx

call.copse (12/7/2012)

---

I thought the question was clearly not about rights, but uniqueness in schemas, and thus not ambiguous, of course it might have been helpful to indicate rights were available....

Yes. You are right. This question is not about schema permissions, it’s only about uniqueness of schema. Under normal settings dbo is the default schema. From next time onwards...

Easy one