Keyword listing in SQL Server 2000

Source: Internet
Author: User

When using SQL Server 2000 to automatically generate SQL scripts, there are some special keywords. I didn't care much about them before, and I didn't remember which one to check and which one to use, this is a simple list (for more information, see the SQL Server online help ........
1. Set quoted_identifier: enables Microsoft SQL server to follow
SQL-92 rules. The identifiers separated by double quotation marks can be reserved keywords of transact-SQL, or contain Transact-SQL
Characters that are not allowed by the identifier syntax rules.
2. Set ansi_nulls: Specifies the SQL-92 of these operators when equal to (=) and not equal to (<>) Comparison operators are used for null values
Compliance.
3. [N] ' Tsql_string ': Is a constant, Tsql_string Yes Nvarchar Or Varchar Data type. If n is included
String will be interpreted Nvarchar Data type. The maximum value is the available memory of the server.
4. object_id: returns the ID of the database object.
5. objectproperty: returns information about objects in the current database. For example, check whether authors is a table,
If objectproperty (object_id ('authors '), 'istable') = 1
Print 'authors is a table'

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.