EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

W

A sub-statement found in the SELECT statement that uses any of various filter conditions, such as BETWEEN, IN, and LIKE, to limit the number of rows retrieved.

Windows application log

The operating system event log used to record application events sent by SQL Server services.

WITH ENCRYPTION

The WITH ENCRYPTION clause protects the definition of your view. If you specify this, you encrypt the definition of your view because you may not want users to display it. Encrypting using WITH ENCRYPTION disallows anyone from using sp_heptext to display your view or viewing it via the Enterprise Manager.

WITH SCHEMABINDING

The WITH SCHEMABINDING option specifies that the view be bound to the schema. This has to be specified when you want to create views with indexes. Also, when WITH SCHEMABINDING is specified, you have to adhere to the owner.object syntax when referencing tables or views in the creation of your view.