Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere 服务器 - SQL 的用法 » 查询和修改数据 » 查询 » WHERE 子句:指定行




SELECT GivenName, Surname
   FROM Contacts
   WHERE GivenName = 'John';

如果 quoted_identifier 数据库选项设置为 Off(缺省设置为 On),则您还可以使用双引号将字符或日期数据括起来。

 ♦ 为当前用户 ID 将 quoted_identifier 选项设置为 OFF
  • 输入以下语句:

    SET OPTION quoted_identifier = 'Off';

提供 quoted_identifier 选项是为了与 Adaptive Server Enterprise 兼容。缺省情况下,Adaptive Server Enterprise 选项 quoted_identifier 设为 Off,而 SQL Anywhere 选项 quoted_identifier 设为 On。