保存将阿拉伯语包含在单元格中的SQL查询

Question

  declare @val nvarchar(max),@H_ARABIC nvarchar(max)
  select @val = 'select [settings_key] as  N''اسم''  from [settings]'
  set @H_ARABIC= @val;
  print @H_ARABIC

它显示为 select [settings_key] as N'???' from [application_setting]但是我该如何获得此结果
select [settings_key] as N'اسم' from [application_setting]我通过更改报价标记尝试了多种方法，但没有用。请帮助

Answer 1

N的字符串前缀。

declare @val nvarchar(max),@H_ARABIC nvarchar(max)
  select @val = N'select [settings_key] as  N''اسم''  from [settings]'
  set @H_ARABIC= @val;
  print @H_ARABIC