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

SAP Sybase SQL Anywhere 16.0 (中文) » SQL Anywhere 服务器 - SQL 用法 » 查询和数据修改 » 查询 » WHERE 子句:指定行




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

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

SET OPTION quoted_identifier = 'Off';

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