Adds brackets or quotes to an identifier.
Syntax
QUOTENAME(str [, quote_char])Example
Enter values below to update the example in real time.
column_name→safe_name→INFORMATION_SCHEMA→COLUMNS→TABLE_NAME→-- 동적 SQL용 안전한 컬럼명
SELECT QUOTENAME(column_name) AS safe_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'employees';