Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Unique constraints Expand / Collapse
Author
Message
Posted Tuesday, July 28, 2009 9:33 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Wednesday, July 29, 2009 12:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 31, 2014 6:18 AM
Points: 85, Visits: 88
There is a little mistake: you don't need tags <strong> and </strong> in question.
Post #761295
Posted Wednesday, July 29, 2009 1:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:05 AM
Points: 1,541, Visits: 8,186
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
Blog Site
Post #761307
Posted Wednesday, July 29, 2009 1:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
tags almost made me choose the wrong option.

"Keep Trying"
Post #761309
Posted Wednesday, July 29, 2009 2:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 7:51 AM
Points: 1,105, Visits: 300
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
Posted Wednesday, July 29, 2009 4:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 5:49 PM
Points: 97, Visits: 58
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
Posted Wednesday, July 29, 2009 6:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 9:47 AM
Points: 2,919, Visits: 2,525
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
Posted Wednesday, July 29, 2009 6:09 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 9:05 AM
Points: 3,412, Visits: 348
The tags are not valid SQL Server syntax. The correct answer should be Statement needs some correction for compile.
Post #761431
Posted Wednesday, July 29, 2009 6:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 18, 2014 2:18 PM
Points: 20, Visits: 879
I am agrry with sjimmo..
Post #761455
Posted Wednesday, July 29, 2009 6:42 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 4, 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 »

Add to briefcase 123»»»

Permissions Expand / Collapse