QUOTENAME Behavior

Question

Post reply

QUOTENAME Behavior

Steve Jones - SSC Editor

SSC Guru

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

#4780080

Comments posted to this topic are about the item QUOTENAME Behavior

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

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

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

Carlo Romagnano

SSC-Insane

Points: 22910

May 27, 2026 at 6:50 am

#4851969

Classic XSS "<asdasd>"!

Neil Burton SSC-Insane Points: 23221 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: 138 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: 9124 More actions · Answer 5

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

This reply was modified 3 days, 21 hours ago by Aaron N. Cutshall.

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