QUOTENAME Behavior

Question

Post reply

QUOTENAME Behavior

Steve Jones - SSC Editor

SSC Guru

Points: 742288
More actions
May 27, 2026 at 12:00 am

#4780080

Comments posted to this topic are about the item QUOTENAME Behavior

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22919 More actions · Answer 1

Carlo Romagnano

SSC-Insane

Points: 22919

May 27, 2026 at 6:50 am

#4851969

Classic XSS "<asdasd>"!

Neil Burton SSC-Insane Points: 23231 More actions · Answer 2

Is one of the answers supposed to be blank?

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

frederico_fonseca SSCoach Points: 16326 More actions · Answer 3

Neil Burton wrote:

Is one of the answers supposed to be blank?

the correct answer was hidden from us!!!

valentin kharchenko SSC Enthusiast Points: 141 More actions · Answer 4

DECLARE @s-2 VARCHAR(20) = 'Steve Jones'

SELECT QUOTENAME(@s, '>') as 'a',

QUOTENAME(@s, '<') as 'b',

QUOTENAME(@s, '><') as 'c',

@@VERSION as ver

FOR XML PATH(''), TYPE

-->>

<ver>Microsoft SQL Server 2025 (RTM-GDR) (KB5091223) - 17.0.1115.1 (X64)

Apr 19 2026 01:00:58

Enterprise Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 26200: ) (Hypervisor)

</ver>

Aaron N. Cutshall SSCrazy Eights Points: 9128 More actions · Answer 5

HTML didn't like the correct answer: <Steve Jones>

This reply was modified 2 weeks, 5 days ago by Aaron N. Cutshall.

LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com

aroggeband-815867 SSC Veteran Points: 238 More actions · Answer 6

aroggeband-815867

SSC Veteran

Points: 238

June 2, 2026 at 1:33 pm

#4859096

<Steve Jones>Steve Jones</Steve Jones>

Steve Jones - SSC Editor SSC Guru Points: 742288 More actions · Answer 7

Lol, apologies everyone. I'll award back points. Apparently my HTML box doesn't escape out HTML characters automatically. I've changed to the & lt ; character instead