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


Unique constraints


Unique constraints

Author
Message
sjimmo
sjimmo
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3742 Visits: 2903
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
Old Hand
Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)

Group: General Forum Members
Points: 313 Visits: 236
I still had the page opened to the question. When I hit refresh, the tags were gone.
Rob Goddard
Rob Goddard
Right there with Babe
Right there with Babe (716 reputation)Right there with Babe (716 reputation)Right there with Babe (716 reputation)Right there with Babe (716 reputation)Right there with Babe (716 reputation)Right there with Babe (716 reputation)Right there with Babe (716 reputation)Right there with Babe (716 reputation)

Group: General Forum Members
Points: 716 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
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

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

Group: General Forum Members
Points: 31946 Visits: 18551
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

Bhavesh_Patel
Bhavesh_Patel
Say Hey Kid
Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)

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



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

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

Tom

TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14204 Visits: 12197
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