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'