Unique constraints

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by ARUN SAS » Unique constraints

28 posts, Page 1 of 3

1 2 3 »»»

Unique constraints

Rate Topic

Display Mode

Topic Options

Author

Message

arun.sas

Posted Tuesday, July 28, 2009 9:33 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,231, Visits: 3,483

Comments posted to this topic are about the item Unique constraints

Post #761244

Andrius-794186

Posted Wednesday, July 29, 2009 12:45 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 4:45 AM
Points: 84, Visits: 76

There is a little mistake: you don't need tags <strong> and </strong> in question.

Post #761295

BrainDonor

Posted Wednesday, July 29, 2009 1:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 1,400, Visits: 6,894

The 'strong' tags means that there is an error, which needs correcting before it will run. Then when it runs it gives the warning, so it either has two answers or it is incorrect to say it gives a warning and completes when it actually gives a syntax error first.

BrainDonor
Linkedin

Post #761307

ChiragNS

Posted Wednesday, July 29, 2009 1:31 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

tags almost made me choose the wrong option.

"Keep Trying"

Post #761309

Kevin Gill

Posted Wednesday, July 29, 2009 2:04 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:18 AM
Points: 932, Visits: 229

Tags DID make me choose the wrong option. I assumed it was asking about some subtlety of how sqlserver deals with unexpected xml elements. As such, I too reckon I was actually right to say it needs correction :o)

-------------------------------
Oh no!

Post #761323

Joe Kelly-376311

Posted Wednesday, July 29, 2009 4:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 5:34 AM
Points: 85, Visits: 49

The query must be corrected before it can run. The < symbol is interpreted as LT, not as XML, so the query will not compile.
A badly needed point denied us ... ;-((

Tks,

JK

Post #761370

sjimmo

Posted Wednesday, July 29, 2009 6:00 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:15 AM
Points: 2,865, Visits: 2,467

The question was about running the code. The code will not run the way it is written. Afte getting it wrong, I tried the code and received an error. Thus, the code needs modification to run. If you are planning to post more questions, please try it before submitting it. The point should be given to all who answered that the code had to be modified.

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

Post #761420

Lee Nadelman

Posted Wednesday, July 29, 2009 6:09 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:59 AM
Points: 2,914, Visits: 281

The tags are not valid SQL Server syntax. The correct answer should be Statement needs some correction for compile.

Post #761431

vinod-385211

Posted Wednesday, July 29, 2009 6:35 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, February 22, 2013 8:13 AM
Points: 20, Visits: 819

I am agrry with sjimmo..

Post #761455

Brian LeBlanc-449582

Posted Wednesday, July 29, 2009 6:42 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 04, 2010 11:18 AM
Points: 547, Visits: 66

--- Incorrect syntax near '<'. ----- They got it wrong.

Brian RL: Be serious about your work, but do not take yourself too seriously {Philip A. Fisher}

Post #761473

« Prev Topic | Next Topic »

28 posts, Page 1 of 3

1 2 3 »»»

Permissions