SQL 关键字

-- quotename : 使字符串变成标识符
select quotename('abc[]def')
select quotename('abc[]def','''')
select quotename('abc[]def','[')
select quotename('abc[]def',']')
select quotename('abc[]def','"')

 

-- CHOOSE：从序列中选择第X个数据

SELECT x,CHOOSE ( x, 'Big', 'Middle', 'Small' ) AS Result from (select cast(NULL as int)x union select 2 union select
3 union select 4)e