|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 1,219,
Visits: 3,120
|
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Monday, November 23, 2009 12:38 AM
Points: 82,
Visits: 39
|
|
| There is a little mistake: you don't need tags <strong> and </strong> in question.
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 392,
Visits: 1,504
|
|
| 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.
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Wednesday, March 03, 2010 5:28 AM
Points: 2,155,
Visits: 1,676
|
|
tags almost made me choose the wrong option.
"Keep Trying"
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Friday, March 19, 2010 3:46 AM
Points: 714,
Visits: 108
|
|
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!
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, March 10, 2010 1:56 PM
Points: 42,
Visits: 12
|
|
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
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Thursday, March 18, 2010 8:53 PM
Points: 1,270,
Visits: 361
|
|
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
It is a narrow mind that cannot see things from more than one point of view. — George Eliot
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Friday, March 19, 2010 6:26 AM
Points: 1,747,
Visits: 138
|
|
| The tags are not valid SQL Server syntax. The correct answer should be Statement needs some correction for compile.
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Monday, March 01, 2010 1:53 PM
Points: 16,
Visits: 50
|
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, March 01, 2010 7:39 AM
Points: 508,
Visits: 64
|
|
--- Incorrect syntax near '<'. ----- They got it wrong.
Brian RL: Be serious about your work, but do not take yourself too seriously {Philip A. Fisher}
|
|
|
|
