لطفا منتظر باشید ...
E
encrypted trigger
A trigger that is created with an optional encryption parameter that encrypts the definition text and cannot be decrypted. Encryption makes the information indecipherable to protect it from unauthorized viewing or use.encryption
A method for keeping sensitive information confidential by changing data into an unreadable format.English Query
A Microsoft application development product that allows users to ask questions in English, rather than in a computer language such as SQL. For example, you might ask, 'How many customers bought products last year?' rather than prepare an equivalent SQL statement.
entity
In English Query, an entity is a real-world object referred to by a noun (person, place, thing, or idea). Entities are semantic objects.entity integrity
A state in which all the rows in a database have a not-null primary key value, all tables have primary keys, and no table has any duplicate primary key values. This ensures that there are no duplicate entries for anything represented in the database.enumeration
A data type of a property. An enumeration specifies that a property value should support a fixed set of constant strings or integer values.equijoin
A join in which the values in the columns being joined are compared for equality, and all columns are included in the results.error log
A text file that records system information from SQL Server.error state number
A number associated with SQL Server 2000 messages that helps Microsoft support engineers find the specific code location that issued the message. This information can be helpful in diagnosing errors that might have been generated from multiple locations in the SQL Server 2000 code.escape character
A character used to indicate that another character in an expression is meant literally and not as an operator. For example, in SQL, the character '%' is used as a wildcard character to mean 'any number of characters in this position.' However, if you want to search for a string such as '10%' (10 percent), you cannot specify '10%' alone as a search string. The '%' would be interpreted as 'any number of characters in addition to 10.' By specifying an escape character, you can flag instances where '%' specifically means percent. For example, if you specify the escape character '#,' you can indicate a search string of '10#%' to mean '10 percent.'exclusive lock
A lock that prevents any other transaction from acquiring a lock on a resource until the original lock on the resource is released at the end of the transaction. An exclusive lock is always applied during an update operation (INSERT, UPDATE, or DELETE).execution plan
The path and user context that the SQL Server query optimizer creates for the execution of a query. Every query must have an execution plan created by the SQL Server query optimizer, and plans can be cached for reuse, providing better performance.explicit transaction
A group of SQL statements enclosed within transaction delimiters. The first delimiter must be either BEGIN_TRANSACTION or BEGIN_DISTRIBUTED_TRANSACTION, and the end delimiter must be one of the following: COMMIT_TRANSACTION, COMMIT_WORK, ROLLBACK_TRANSACTION, ROLLBACK_WORK, or SAVE_TRANSACTION.expression
In SQL, a combination of symbols and operators that evaluates to a single data value. Simple expressions can be a constant, a variable, a column, or a scalar function. Complex expressions are one or more simple expressions connected by operators.extended stored procedure
A function in a dynamic link library (DLL) that is coded by using the SQL Server 2000 Extended Stored Procedure API. The function can then be invoked from Transact-SQL by using the same statements that are used to execute Transact-SQL stored procedures. Extended stored procedures can be built to perform functionality not possible with Transact- SQL stored procedures.eXtensible Markup Language (XML)
Self-describing data in a hypertext format. XML provides for hierarchical data display and is becoming the standard data format for the Internet. Along with the data, the column or attribute names are displayed, and a schema can be included as well.
extent
The unit of space allocated to a SQL Server object, such as a table or index, whenever the object needs more space. In SQL Server 2000, an extent is eight contiguous pages.
