SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unique constraints


Unique constraints

Author
Message
sjimmo
sjimmo
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7331 Visits: 2913
I had the correct answer as well, until I reread the question, which specifically said to run that code, and actually had a correct answer to it. Thus, 40% of those who answered got it wrong, which for a simple question as this should have been - is a bit high. I see that they have fixed the code, but are not going to give credit to those who answered it correctly and since we do not gat a 2nd chance to answer, many people lose.

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
sql_monkey
sql_monkey
Mr or Mrs. 500
Mr or Mrs. 500 (569 reputation)Mr or Mrs. 500 (569 reputation)Mr or Mrs. 500 (569 reputation)Mr or Mrs. 500 (569 reputation)Mr or Mrs. 500 (569 reputation)Mr or Mrs. 500 (569 reputation)Mr or Mrs. 500 (569 reputation)Mr or Mrs. 500 (569 reputation)

Group: General Forum Members
Points: 569 Visits: 236
I still had the page opened to the question. When I hit refresh, the tags were gone.
Rob Goddard
Rob Goddard
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1618 Visits: 558
sql_monkey (7/29/2009)
I still had the page opened to the question. When I hit refresh, the tags were gone.


LeChuck took them!!

Crazy

..puts down phone and gets coat...

--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams
OCTom
OCTom
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5957 Visits: 4152
Sometimes it pays to be late to answer a question. ;-)
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143343 Visits: 18649
The question must have been corrected by the time I answered it. The sql errors with the tags did not exist when I answered this question so it was a little more straight forward.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Learn Extended Events

Bhavesh_Patel
Bhavesh_Patel
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1303 Visits: 297
Hey I got it right.



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Tom Thomson
Tom Thomson
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50330 Visits: 13149
Oh **1t! 600+400 > 900. And I was a mathematician, once upon a time. How did I get that wrong!

Tom

Tom Thomson
Tom Thomson
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50330 Visits: 13149
sjimmo (7/29/2009)
I had the correct answer as well, until I reread the question, which specifically said to run that code, and actually had a correct answer to it. Thus, 40% of those who answered got it wrong, which for a simple question as this should have been - is a bit high. I see that they have fixed the code, but are not going to give credit to those who answered it correctly and since we do not gat a 2nd chance to answer, many people lose.

Oh come on, points for QOTD are neither here nor there - if you can get 8 points (or whatever the number was) for knowing that you Estados Unidensians (well, I mustn't say "Yanks", must I) have fireworks on July 4th (is that scoring an indication of an anti-European bias? Probably yes, but it will be an unintentional one, and who gives a damn anyway) then who cares about 1 point for something as boring as this?

Tom

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search